Re: [HACKERS] Re: [GENERAL] Postgres INSERTs much slower than MySQL?

Vadim Mikheev <vadim@krs.ru>

From: Vadim Mikheev <vadim@krs.ru>
To: t-ishii@sra.co.jp
Cc: Lincoln Yeoh <lylyeoh@mecomb.com>, pgsql-general@postgreSQL.org, PostgreSQL Developers List <hackers@postgreSQL.org>
Date: 1999-10-26T02:00:24Z
Lists: pgsql-hackers
Tatsuo Ishii wrote:
> 
> > With WAL the same test without -F will be near as fast as with
> > -F now.
> 
> This sounds impressive. So I did some testings with my pgbench to see
> how WAL improves the performance without -F using current.
> 
> 100000 records insertation + vacuum took 1:02 with -F (4:10 without -F)
> 
> TPC-B like transactions(mix of insert/update/select) per second:
>         21 (with -F)
>         3  (without -F)
> 
> I couldn't see any improvement against 6.5.2 so far. Maybe some part
> of WAL is not yet committed to current?
         ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
...is not implemented.

Vadim