On Feb 22, 2010, at 6:47 PM, Greg Smith wrote: > Ben Chobot wrote: >> Is it reading it correctly to say that the bgwriter probably wouldn't help >> much, because a majority of the dirty pages appear to be popular? > > Yes. The background writer cleaner process only does something useful if > there are pages with low usage counts it can evict. You would need to > increase shared_buffers significantly before it's likely that would happen. > Right now, 87% of your buffer cache has a usage count of 2 or higher, which > basically means it's filled with almost nothing but the working set of data > it never wants to evict unless it's for a checkpoint.
Hm, my shared_buffers is already 10GB, but I'm using about 80GB for filesystem cache. Would a larger shared_buffers make sense? I thought I read somewhere that 10GB is on the high end of the useful size for shared_buffers. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
