On Wed, Sep 5, 2012 at 2:16 PM, jam3 <jamorton3@xxxxxxxxx> wrote: > Here is a bash script I wrote to print out mem config ffrom postgresconf.sql > and os (centos 5.5 in this case). According to Gregory Smith in Postgresql > 9.0 shared buffers should be appx 25-40% of avail Physical RAM. Also > considerPostgres uses the OS Buffer as it access the physical data and log > files and while doing so has the potential to double buffer blocks. > > WorkMEM is suggested at 5% but if you do alot of CLUSTER/ANALYZE/VACUUM you > will want to up this, I usually round off to the highest power of 2 is 5% is > 328mb i'll set it to 512. I think you mean maintenance_work_mem here, as regular vacuum or analyze don't use work_mem. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
