Re: Spread checkpoint sync - Mailing list pgsql-hackers

From Greg Smith
Subject Re: Spread checkpoint sync
Date
Msg-id 4D34F0ED.6070902@2ndquadrant.com
Whole thread Raw
In response to Re: Spread checkpoint sync  (Bruce Momjian <bruce@momjian.us>)
Responses Re: Spread checkpoint sync  (Cédric Villemain <cedric.villemain.debian@gmail.com>)
List pgsql-hackers
Bruce Momjian wrote:
> Should we be writing until 2:30 then sleep 30 seconds and fsync at 3:00?
>   

The idea of having a dead period doing no work at all between write 
phase and sync phase may have some merit.  I don't have enough test data 
yet on some more fundamental issues in this area to comment on whether 
that smaller optimization would be valuable.  It may be a worthwhile 
concept to throw into the sequencing.

-- 
Greg Smith   2ndQuadrant US    greg@2ndQuadrant.com   Baltimore, MD
PostgreSQL Training, Services, and 24x7 Support  www.2ndQuadrant.us
"PostgreSQL 9.0 High Performance": http://www.2ndQuadrant.com/books



pgsql-hackers by date:

Previous
From: Josh Kupershmidt
Date:
Subject: Re: psql: Add \dL to show languages
Next
From: Robert Haas
Date:
Subject: Re: estimating # of distinct values