Skip site navigation (1) Skip section navigation (2)

Re: restore time: sort_mem vs. checkpoing_segments

From: Dennis Bjorklund <db(at)zigo(dot)dhs(dot)org>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: Vivek Khera <khera(at)kcilink(dot)com>,<pgsql-performance(at)postgresql(dot)org>
Subject: Re: restore time: sort_mem vs. checkpoing_segments
Date: 2003-09-24 05:24:26
Message-ID: Pine.LNX.4.44.0309240721430.352-100000@zigo.dhs.org (view raw or flat)
Thread:
Lists: pgsql-performance
On Tue, 23 Sep 2003, Bruce Momjian wrote:

> With the new warning about too-frequent checkpoints, people have actual
> feedback to encourage them to increase checkpoint_segments.  One issue
> is that it is likely to recommend increasing checkpoint_segments during
> restore, even if there is no value to it being large during normal
> server operation.  Should that be decumented?

One could have a variable that turns off that warning, and have pg_dump
insert a statement to turn it off. That is, if one never want these
warnings from a restore (from a new dump).

In any case, documentation is good and still needed.

-- 
/Dennis


In response to

pgsql-performance by date

Next:From: peterDate: 2003-09-24 05:48:15
Subject: Performance issue
Previous:From: Dennis BjorklundDate: 2003-09-24 05:20:44
Subject: Re: LIKE query running slow

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group