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.marlowe@gmail.com> wrote:
> On Thu, Aug 30, 2012 at 8:42 AM, Scott Marlowe <scott.marlowe@gmail.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