On Sat, Apr 23, 2011 at 12:24 PM, Robert Haas <robertmh...@gmail.com> wrote:

> One thing to watch is the size of the filesystem cache. Generally as the 
> system comes under memory pressure you will see the cache shrink. Not sure 
> what is happening on your system, but typically when it gets down to some 
> minimal size, that's when the swapping starts.
>
> ...Robert

Thanks everyone, I've tuned the system in the tune of overcommit 2 and
ratio of 80% this makes my commit look like:
CommitLimit:    31694880 kB
Committed_AS:    2372084 kB


So with 32G of system memory and 4gb cache so far it's running okay,
no ooms in the last 2 days and the DB is performing well again. I've
also dropped the shared buffers to 2gb, that gives me 1 gb for data
etc. I'll test with smaller 1.5gb if need be.

I've already started the 64bit process, I've got to test if slon will
replicate between a 32bit and 64 bit system, if the postgres/slon
versions are the same (slon being the key here). If this works, I will
be able to do the migration to 64bit that  much easier, if not well,
ya that changes the scheme a ton.

Thanks for the all the assistance in this, it's really appreciated

Tory

-- 
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance

Reply via email to