On 3/22/10 4:36 PM, Carlo Stonebanks wrote:
> Here we go again!
> Can anyone see any obvious faults?
> 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 James||Date: 2010-03-22 23:46:13|
|Subject: Re: Block at a time ...|
|Previous:||From: Eger, Patrick||Date: 2010-03-22 23:12:07|
|Subject: Re: PostgreSQL upgraded to 8.2 but forcing index scan on query produces faster |