Tatsuo Ishii wrote:
What's the problem with 18GB shared_buffers exactly
It's slower than smaller numbers, and if you actually dirty a significant portion of it you can have a checkpoint that takes hours to sync, completely trashing system responsiveness for a good portion of it.
-- Greg Smith 2ndQuadrant US Baltimore, MD PostgreSQL Training, Services and Support greg@xxxxxxxxxxxxxxx www.2ndQuadrant.us -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general