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@archonet.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