Re: Postgres slower than MS ACCESS - Mailing list pgsql-performance

From Tom Lane
Subject Re: Postgres slower than MS ACCESS
Date
Msg-id 19881.1140039411@sss.pgh.pa.us
Whole thread Raw
In response to Re: Postgres slower than MS ACCESS  ("Jay Greenfield" <jag@timberline.ca>)
List pgsql-performance
"Jay Greenfield" <jag@timberline.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

pgsql-performance by date:

Previous
From: Gary Doades
Date:
Subject: Re: Strange Create Index behaviour
Next
From: Tom Lane
Date:
Subject: Re: Strange Create Index behaviour