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.
In response to
pgsql-performance by date
|Next:||From: peter||Date: 2003-09-24 05:48:15|
|Subject: Performance issue|
|Previous:||From: Dennis Bjorklund||Date: 2003-09-24 05:20:44|
|Subject: Re: LIKE query running slow|