On Thu, Jul 25, 2013 at 6:23 AM, McKinzie, Alan (Alan) <alanmck@xxxxxxxxx> wrote: > FYI – I am using smem (on a linux server) to monitor the memory allocated to > our Database connections. In an attempt to lower our memory footprint, I > lowered our setting for work_mem from 1MB down to 500kB (in addition I > enabled log_temp_files to see the SQL statements that now use temp files for > sorting and hash operations). 1MB is already pretty small. If you have a lot of connections all using temp space at the same time, you should probably consider using a connection pooler to limit that number and then increasing work_mem, rather than decreasing it. Cheers, Jeff -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
