Re: checkpoint_segments 32 megs? - Mailing list pgsql-hackers

From Josh Berkus
Subject Re: checkpoint_segments 32 megs?
Date
Msg-id 200507211106.54656.josh@agliodbs.com
Whole thread Raw
In response to Re: checkpoint_segments 32 megs?  (Simon Riggs <simon@2ndquadrant.com>)
List pgsql-hackers
People,

> So, overall, I see no reason to change that feature.

Me neither.  If people are concerned about WAL on-disk size, they can reduce 
the number of segments.    In my experience, anyway, high segment numbers 
don't provide any benefit unless you have a dedicated WAL disk.

-- 
Josh Berkus
Aglio Database Solutions
San Francisco


pgsql-hackers by date:

Previous
From: Josh Berkus
Date:
Subject: Re: Checkpoint cost, looks like it is WAL/CRC
Next
From: Bruce Momjian
Date:
Subject: Re: Imprecision of DAYS_PER_MONTH