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@xxxxxxxxx> wrote:
> On Thu, Aug 30, 2012 at 8:42 AM, Scott Marlowe <scott.marlowe@xxxxxxxxx> 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
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
