On 06/26/11 4:10 PM, Dave Coventry wrote:

work_mem: 64kB
shared_buffers: 128kB
maintenance_work_mem: 1MB

I'll see if that makes any difference.

I'd watch the systems' memory usage as shown by `top` or `free`... as long as the 'cached' value (add in 'free' if its significant) stays reasonably large (say, 25-50% of your total ram), you're in good shape. using values as small as the defaults likely will degrade performance of the queries. postgres will behave somewhat more optimally if the 'estimated_cache_size' is near the 'cached' value.


--
john r pierce                            N 37, W 122
santa cruz ca                         mid-left coast


--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to