Re: Trying to minimize the impact of checkpoints

From: Jan Wieck <JanWieck(at)Yahoo(dot)com>
To: Jack Orenstein <jao(at)geophile(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Trying to minimize the impact of checkpoints
Date: 2004-06-12 20:30:13
Message-ID: 40CB67D5.1040306@Yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(at)Yahoo(dot)com #

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2004-06-12 20:53:38 Re: [HACKERS] Release 7.4.3 branded
Previous Message Tom Lane 2004-06-12 20:00:46 Re: Trying to minimize the impact of checkpoints