Re: Postgres slower than MS ACCESS

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Jay Greenfield" <jag(at)timberline(dot)ca>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Postgres slower than MS ACCESS
Date: 2006-02-15 21:36:51
Message-ID: 19881.1140039411@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

"Jay Greenfield" <jag(at)timberline(dot)ca> writes:
> I did a run with checkpoint_segments @ 30 (from 3 in 4.35 min run) and
> posted a time of 6.78 minutes. Any idea why this would increase the time?

The first time through might take longer while the machine creates empty
xlog segment files (though I'd not have expected a hit that big). Once
it's fully populated pg_xlog it'll just recycle the files, so you might
find that a second try is faster.

regards, tom lane

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Gary Doades 2006-02-15 21:47:46 Re: Strange Create Index behaviour
Previous Message Gary Doades 2006-02-15 21:34:11 Re: Strange Create Index behaviour