Luke Lonergan wrote:
>>>Time: 197870.105 ms
>>So 198 seconds is the uncached read time with count (Just for clarity,
>>did you clear the Pg and filesystem caches or unmount / remount the
> Nope - the longer time is due to the "second write" known issue with
> Postgres - it writes the data to the table, but all of the pages are marked
> dirty? So, always on the first scan after loading they are written again.
> This is clear as you watch vmstat - the pattern on the first seq scan is
> half read / half write.
Ah - indeed - first access after a COPY no? I should have thought of
In response to
pgsql-performance by date
|Next:||From: Sven Geisler||Date: 2005-11-24 10:38:47|
|Subject: Re: High context switches occurring|
|Previous:||From: Mark Kirkwood||Date: 2005-11-24 09:24:35|
|Subject: Re: Hardware/OS recommendations for large databases (|