Re: Auto-tuning work_mem and maintenance_work_mem

On 10/09/2013 02:15 PM, Bruce Momjian wrote:
> and for shared_buffers of 2GB:
> 
>     test=> show shared_buffers;
>      shared_buffers
>     ----------------
>      2GB
>     (1 row)
>     
>     test=> SHOW work_mem;
>      work_mem
>     ----------
>      6010kB
>     (1 row)

Huh?  Only 6MB work_mem for 8GB RAM?  How'd you get that?

That's way low, and frankly it's not worth bothering with this if all
we're going to get is an incremental increase.  In that case, let's just
set the default to 4MB like Robert suggested.

-- 
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com