From: | Jochen Erwied <jochen(at)pgsql-performance(dot)erwied(dot)eu> |
---|---|
To: | Uwe Bartels <uwe(dot)bartels(at)gmail(dot)com> |
Cc: | pgsql-performance(at)postgresql(dot)org, pgsql-performance(at)postgresql(dot)org |
Subject: | Re: buffercache/bgwriter |
Date: | 2011-03-23 13:19:59 |
Message-ID: | 6010559739.20110323141959@erwied.eu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
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(at)erwied(dot)eu +49-208-38800-18, FAX: -19
Sauerbruchstr. 17 | work: joe(at)mbs-software(dot)de +49-2151-7294-24, FAX: -50
D-45470 Muelheim | mobile: jochen(dot)erwied(at)vodafone(dot)de +49-173-5404164
From | Date | Subject | |
---|---|---|---|
Next Message | Shaun Thomas | 2011-03-23 13:34:29 | Re: Re-Reason of Slowness of Query |
Previous Message | Shaun Thomas | 2011-03-23 13:13:28 | Re: good old VACUUM FULL |