On May 25, 2012, at 7:12 PM, Tom Lane wrote: > Jeff Frost <j...@pgexperts.com> writes: >> In our customer's case, the size of pg_attribute was a little less than 1/4 >> of shared_buffers, so might not be the syncscan? > > Could you go back and double check that? If the shared_buffers setting > were 7GB not 8GB,
It definitely started happening with 8GB of shared_buffers. We actually tried reducing shared_buffers to 2GB to see if we were writing out too many dirty buffers at checkpoint time or something, but that had no effect, so we put it back to 8GB. -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
