On Fri, Apr 9, 2010 at 10:03 AM, Greg Smith <greg@xxxxxxxxxxxxxxx> wrote: > The main problem with this configuration is that work_mem is set to an > unsafe value--1.6GB. With potentially 400 connections and about 2GB of RAM > free after starting the server, work_mem='4MB' is as large as you can safely > set this. > maintenance_work_mem | kB | 256MB Note that 256MB maintenance_work_mem on a machine with 3 autovac threads and only 2 Gig free is kinda high too. -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
