Re: [HACKERS] Re: [GENERAL] Postgres INSERTs much slower than MySQL? - Mailing list pgsql-general

From Vadim Mikheev
Subject Re: [HACKERS] Re: [GENERAL] Postgres INSERTs much slower than MySQL?
Date
Msg-id 38150B38.4A3CABF7@krs.ru
Whole thread Raw
In response to Re: [HACKERS] Re: [GENERAL] Postgres INSERTs much slower than MySQL?  (Tatsuo Ishii <t-ishii@sra.co.jp>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Lincoln Yeoh
Date:
Subject: Re: [GENERAL] current_timestamp and default now()
Next
From: Bruce Momjian
Date:
Subject: Re: [GENERAL] select max(oid)