Re: WAL Internals question

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Fabrice Franquenk <Fabrice(dot)Franquenk(at)bull(dot)net>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: WAL Internals question
Date: 2006-07-04 18:18:11
Message-ID: 25523.1152037091@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Fabrice Franquenk <Fabrice(dot)Franquenk(at)bull(dot)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

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Petronenko D.S. 2006-07-04 18:35:37 Re: copy recursive data
Previous Message Fabrice Franquenk 2006-07-04 15:44:41 WAL Internals question