| From: | Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us> |
|---|---|
| To: | Vadim Mikheev <vadim(at)krs(dot)ru> |
| Cc: | Lincoln Yeoh <lylyeoh(at)mecomb(dot)com>, pgsql-general(at)postgreSQL(dot)org, PostgreSQL Developers List <hackers(at)postgreSQL(dot)org> |
| Subject: | Re: [GENERAL] Postgres INSERTs much slower than MySQL? |
| Date: | 1999-10-22 06:04:09 |
| Message-ID: | 199910220604.CAA28175@candle.pha.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers |
> WAL is Write Ahead Log, transaction logging.
> This will reduce # of fsyncs (among other things) Postgres has
> to perform now.
> Test above took near 38 min without -F flag and 24 min
> with -F (no fsync at all).
> With WAL the same test without -F will be near as fast as with
> -F now.
>
> But what makes me unhappy right now is that with -F COPY FROM takes
> JUST 3 min !!! (And 16 min without -F)
> Isn't parsing/planning overhead toooo big ?!
Yikes. I always thought it would be nice to try and cache query plans
by comparing parse trees, and if they match cached versions, replace any
constants with new ones and use cached query plan. Hard to do right,
though.
--
Bruce Momjian | http://www.op.net/~candle
maillist(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Gene Selkov, Jr. | 1999-10-22 06:18:47 | Re: What's WAL (wasRe: [GENERAL] Postgres INSERTs much slower than MySQL?) |
| Previous Message | Vadim Mikheev | 1999-10-22 05:52:40 | Re: [GENERAL] Postgres INSERTs much slower than MySQL? |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 1999-10-22 06:04:29 | Re: [HACKERS] Planning final assault on query length limits |
| Previous Message | Vadim Mikheev | 1999-10-22 05:52:40 | Re: [GENERAL] Postgres INSERTs much slower than MySQL? |