Hi Jochen,
yes, I had that impression too.
But it is running. ...And has almost no effect. I changed all parameter to the most aggressive, but....
Before I restarted the server I had a percentage of writes by the bgwriter of less that 1 percent.
postgres=# select name,setting from pg_settings where name like 'bgw%'; name | setting-------------------------+--------- bgwriter_delay | 10 bgwriter_lru_maxpages | 1000 bgwriter_lru_multiplier | 10Best...
Uwe
Uwe Bartels
Systemarchitect - Freelancer
mailto:
uwe.bartels@gmail.comtel: +49 172 3899006
profile:
https://www.xing.com/profile/Uwe_Bartels website:
http://www.uwebartels.comOn 23 March 2011 14:19, Jochen Erwied
<jochen@pgsql-performance.erwied.eu> wrote:
Wednesday, March 23, 2011, 1:51:31 PM you wrote:
[rearranged for quoting]
> background writer stats
> checkpoints_timed | checkpoints_req | buffers_checkpoint | buffers_clean |
> maxwritten_clean | buffers_backend | buffers_alloc
> -------------------+-----------------+--------------------+---------------+------------------+-----------------+---------------
> 3 | 0 | 99754 | 0
> | 0 | 115307 | 246173
> (1 row)
buffers_clean = 0 ?!
> But I don't understand how postgres is unable to fetch a free buffer.
> Does any body have an idea?
Somehow looks like the bgwriter is completely disabled. How are the
relevant settings in your postgresql.conf?
--
Jochen Erwied | home: jochen@erwied.eu +49-208-38800-18, FAX: -19
Sauerbruchstr. 17 | work: joe@mbs-software.de +49-2151-7294-24, FAX: -50
D-45470 Muelheim | mobile: jochen.erwied@vodafone.de +49-173-5404164