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