> Shared buffers is the cache maintained by PostgreSQL. All all the data > that you read/write need to go through shared buffers.
While this is technically true, I need to point out that you generally increase shared_buffers for high concurrency, and for reads, not for writes, especially for row-at-a-time inserts. There's just not that much memory required (although more than the out-of-the-box defaults). I'd suggest increasing wal_buffers to 16MB, which is the maximum useful amount, rather than 5MB. -- Josh Berkus PostgreSQL Experts Inc. http://pgexperts.com -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
