From: | "Jeremy Haile" <jhaile(at)fastmail(dot)fm> |
---|---|
To: | pgsql-performance(at)postgresql(dot)org |
Subject: | Re: Config parameters |
Date: | 2007-01-02 17:06:24 |
Message-ID: | 1167757584.31784.282774689@webmail.messagingengine.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2007-01-02 17:30:24 | Re: Slow dump? |
Previous Message | Erik Jones | 2007-01-02 16:41:53 | Slow dump? |