Skip site navigation (1) Skip section navigation (2)

Re: Got that new server, now it's time for config!

From: Dan Harris <fbsd(at)drivefaster(dot)net>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Got that new server, now it's time for config!
Date: 2010-03-22 23:16:31
Message-ID: 4BA7FA4F.9050400@drivefaster.net (view raw or flat)
Thread:
Lists: pgsql-performance
On 3/22/10 4:36 PM, Carlo Stonebanks wrote:
> Here we go again!
>
> Can anyone see any obvious faults?
>
> Carlo
>
> maintenance_work_mem = 256MB
I'm not sure how large your individual tables are, but you might want to 
bump this value up to get faster vacuums.
> max_fsm_relations = 1000
I think this will definitely need to be increased
> work_mem = 64MB
Most data warehousing loads I can think of will need more work_mem, but 
this depends on how large of data sets you are planning to sort.


In response to

pgsql-performance by date

Next:From: Craig JamesDate: 2010-03-22 23:46:13
Subject: Re: Block at a time ...
Previous:From: Eger, PatrickDate: 2010-03-22 23:12:07
Subject: Re: PostgreSQL upgraded to 8.2 but forcing index scan on query produces faster

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group