| From: | Vadim Mikheev <vadim(at)krs(dot)ru> |
|---|---|
| To: | t-ishii(at)sra(dot)co(dot)jp |
| Cc: | Lincoln Yeoh <lylyeoh(at)mecomb(dot)com>, pgsql-general(at)postgreSQL(dot)org, PostgreSQL Developers List <hackers(at)postgreSQL(dot)org> |
| Subject: | Re: [HACKERS] Re: [GENERAL] Postgres INSERTs much slower than MySQL? |
| Date: | 1999-10-26 02:00:24 |
| Message-ID: | 38150B38.4A3CABF7@krs.ru |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Courtney Thomas | 1999-10-26 02:19:30 | Re: [GENERAL] initdb error->ld-elf.so.1: Shared object "libpq.so.2" not found^H |
| Previous Message | Lincoln Yeoh | 1999-10-26 01:07:51 | Re: [GENERAL] current_timestamp and default now() |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 1999-10-26 03:55:45 | Re: [HACKERS] Path-length follies |
| Previous Message | The Hermit Hacker | 1999-10-26 01:01:05 | Re: [HACKERS] RFC: Industrial-strength logging |