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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
