AI Rumman wrote:
* What is the difference between shared_buffers and effective_cache_size?
This whole topic is covered at
http://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server and the
additional references that document leads to.
* If I set effective cache size 1GB for db1 and 500 MB for db2, then
what will happen to the system memory usage?
Nothing; effective_cache_size doesn't impact system memory usage
directly. And I don't think you can set effective_cache_size
differently for each database anyway.
--
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
