Re: WAL Internals question - Mailing list pgsql-novice

From Tom Lane
Subject Re: WAL Internals question
Date
Msg-id 25523.1152037091@sss.pgh.pa.us
Whole thread Raw
In response to WAL Internals question  (Fabrice Franquenk <Fabrice.Franquenk@bull.net>)
Responses Re: WAL Internals question
List pgsql-novice
Fabrice Franquenk <Fabrice.Franquenk@bull.net> writes:
> Now i tried to set the bgwriter_lru_percent to 100% and
> bgwriter_lru_maxpages to 1000 and
> i did not spot any difference with the disk activities, cpu occupation
> or anything else from

Hmm, are you sure your changes took effect?  To get the bgwriter's
attention you need to make the change in postgresql.conf and then
SIGHUP or restart the postmaster.  I'd have thought you could easily
measure a difference given that much change ...

            regards, tom lane

pgsql-novice by date:

Previous
From: Fabrice Franquenk
Date:
Subject: WAL Internals question
Next
From: "Petronenko D.S."
Date:
Subject: Re: copy recursive data