Skip site navigation (1) Skip section navigation (2)

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

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 (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-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

In response to

pgsql-hackers by date

Next:From: Tom LaneDate: 1999-10-22 06:04:29
Subject: Re: [HACKERS] Planning final assault on query length limits
Previous:From: Vadim MikheevDate: 1999-10-22 05:52:40
Subject: Re: [GENERAL] Postgres INSERTs much slower than MySQL?

pgsql-general by date

Next:From: Gene Selkov, Jr.Date: 1999-10-22 06:18:47
Subject: Re: What's WAL (wasRe: [GENERAL] Postgres INSERTs much slower than MySQL?)
Previous:From: Vadim MikheevDate: 1999-10-22 05:52:40
Subject: Re: [GENERAL] Postgres INSERTs much slower than MySQL?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group