Re: Would my postgresql 8.4.12 profit from doubling RAM?

Hello, thank you for your replies and sorry for the delay in my replying -

On Thu, Aug 30, 2012 at 4:45 PM, Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> wrote:
> On Thu, Aug 30, 2012 at 8:42 AM, Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> wrote:
>> users, and currently work_mem is set to 1M (the default.) If you
>> increase that to 16M, that'd be max 1.6G of memory, which you have
>> free anyway right now.

I did look at the vmstat output, but can't deduce anything from it:

# free -m
total used free shared buffers cached
Mem: 15862 13289 2573 0 588 8407
-/+ buffers/cache: 4293 11569
Swap: 2046 0 2046

# vmstat
procs -----------memory---------- ---swap-- -----io---- --system-- -----cpu-----
r b swpd free buff cache si so bi bo in cs us sy id wa st
5 0 256 2610788 602424 8605344 0 0 0 112 0 0 10
0 88 1 0

I'll try changing work_mem to 2MB first - once I upgrade the RAM.

Regards
Alex