Re: about effective_cache_size

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@2ndQuadrant.com   www.2ndQuadrant.us