> I tried work_mem and maintenance_work_mem but it does not seem to make much
> difference yet. Admittedly I had set it to 100M and 80M, so after reading a
> little bit more I have found that I could easily set it to several GBs. But
> I am not sure those are the correct config parameters to use for this. I
> havent found any others that are relevant so far.
You probably want to increase shared_buffers by quite a large amount
and maybe make work_mem not quite so big.
If you have 2GB of memory you might set shared_buffers to 1GB,
work_mem 16MB, maintenance_work_mem 64MB?
In response to
pgsql-performance by date
|Next:||From: Bruno Baguette||Date: 2009-01-22 15:36:31|
|Subject: Slow HashAggregate : How to optimize ?|
|Previous:||From: Thomas Finneid||Date: 2009-01-22 12:35:31|
|Subject: Re: caching written values?|