On Sat, Apr 23, 2011 at 12:24 PM, Robert Haas <robertmhaas@xxxxxxxxx> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
