Horton

Re: Oracle vs PostgreSQL in real life

Mattew T. O'Connor <matthew@rh71.postgresql.org>

View thread View on postgr.es
From: "Mattew T. O'Connor" <matthew@rh71.postgresql.org>
To: Jean-Paul ARGUDO <jean-paul.argudo@idealx.com>, Alex Avriette <a_avriette@acs.org>
Cc: "'Jean-Paul ARGUDO'" <jean-paul.argudo@idealx.com>, pgsql-hackers@postgresql.org, sdinot@idealx.com, dbarth@idealx.com, nicolas.niclausse@idealx.com
Date: 2002-02-27T23:35:33Z
Lists: pgsql-hackers 
> shared_buffers = 19000          # 2*max_connections, min 16

This number sounds too high.  If you only have 256M RAM, this is using over 
150 of it.  Are you swapping alot?  What is the load on the server while it's 
runing?