Re: buffercache/bgwriter
От
Jochen Erwied
Тема
Re: buffercache/bgwriter
Дата
Msg-id
6010559739.20110323141959@erwied.eu
Ответ на
buffercache/bgwriter (Uwe Bartels)
Список
Дерево обсуждения
buffercache/bgwriter Uwe Bartels <uwe.bartels@gmail.com>
Re: buffercache/bgwriter Jochen Erwied <jochen@pgsql-performance.erwied.eu>
Re: buffercache/bgwriter Jeff Janes <jeff.janes@gmail.com>
Re: buffercache/bgwriter Uwe Bartels <uwe.bartels@gmail.com>
Re: buffercache/bgwriter Cédric Villemain <cedric.villemain.debian@gmail.com>
Re: buffercache/bgwriter Uwe Bartels <uwe.bartels@gmail.com>
Re: buffercache/bgwriter Greg Smith <greg@2ndQuadrant.com>
Re: buffercache/bgwriter Uwe Bartels <uwe.bartels@gmail.com>
Re: buffercache/bgwriter Uwe Bartels <uwe.bartels@gmail.com>
Re: buffercache/bgwriter tv@fuzzy.cz
Re: buffercache/bgwriter "Nicholson, Brad (Toronto, ON, CA)" <bnicholson@hp.com>
Re: buffercache/bgwriter Uwe Bartels <uwe.bartels@gmail.com>
Re: buffercache/bgwriter Jeff Janes <jeff.janes@gmail.com>
Re: buffercache/bgwriter Uwe Bartels <uwe.bartels@gmail.com>
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
В списке pgsql-performance по дате отправления
