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
In response to AI Rumman :
> * What is the difference between shared_buffers and effective_cache_size?
effective_cache_size:
Sets the planner's assumption about the effective size of the disk cache
that is available to a single query. This parameter has no effect on the
size of shared memory alloc
* What is the difference between shared_buffers and effective_cache_size?
* If I set effective cache size 1GB for db1 and 500 MB for db2, then what
will happen to the system memory usage?
Anyone please tell me.
