On Wed, Sep 5, 2012 at 2:16 PM, jam3 <jamorton3@gmail.com> 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.