Re: Trying to minimize the impact of checkpoints

On 6/12/2004 3:44 PM, Jack Orenstein wrote:
> Jan Wieck wrote:
>> On 6/12/2004 1:44 PM, Jack Orenstein wrote:
>>
>>> Any opinions on the stability of 7.5 and the effectiveness of the
>>> background writer in reducing variability in performance due to checkpoints?
>>
>> I didn't save any of the charts done with 7.4, but the responsetime
>> spikes on checkpoints went up to 60 seconds without the bgwriter. If you
>> look at the last chart on this page
>>
>>     http://developer.postgresql.org/~wieck/vacuum_cost/
>>
>> there are no spikes at all.
>
> This looks very promising. Our product should be installed by then. Do you know
> what the process of migrating from 7.4.2 to 7.5 will be? Will it be simply a
> software upgrade or will databases have to be modified in some way?

As usual, dump and restore. Or (if you have backup hardware) you use the
Slony (http://gborg.postgresql.org/project/slony1/projdisplay.php)
replication systems switchover capability for upgrading.


Jan

--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck@Yahoo.com #