Re: Config parameters

["Jeremy Haile" <jhaile(at)fastmail(dot)fm>]

What is a decent default setting for work_mem and maintenance_work_mem,
considering I am regularly querying tables that are tens of millions of
rows and have 2-4 GB of RAM?

Also - what is the best way to determine decent settings for
temp_buffers and random_page_cost?


On Tue, 02 Jan 2007 16:34:19 +0000, "Richard Huxton" <dev(at)archonet(dot)com>
said:
> Jeremy Haile wrote:
> > I'm curious what parameters you guys typically *always* adjust on new
> > PostgreSQL installs.  
> 
> > The parameters that I almost always change when installing a new system
> > is shared_buffers, max_fsm_pages, checkpoint_segments, and
> > effective_cache_size.
> 
> Always: work_mem, maintenance_work_mem
> Also consider temp_buffers and random_page_cost.
> 
> A lot will depend on how much of the data you handle ends up cached.
> 
> -- 
>    Richard Huxton
>    Archonet Ltd