On Tue, 30 Mar 2010, Faheem Mitha wrote:
work_mem = 1 GB (see diag.{tex/pdf}).Sure, but define sane setting, please. I guess part of the point is that I'm trying to keep memory low
You're trying to keep memory usage low, but you have work_mem set to 1GB? Matthew -- "Prove to thyself that all circuits that radiateth and upon which thou worketh are grounded, lest they lift thee to high-frequency potential and cause thee to radiate also. " -- The Ten Commandments of Electronics -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
