| From: | Greg Smith <greg(at)2ndquadrant(dot)com> |
|---|---|
| To: | AI Rumman <rummandba(at)gmail(dot)com> |
| Cc: | pgsql-general General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: about effective_cache_size |
| Date: | 2010-02-18 09:04:47 |
| Message-ID: | 4B7D02AF.104@2ndquadrant.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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(at)2ndQuadrant(dot)com www.2ndQuadrant.us
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Yeb Havinga | 2010-02-18 09:16:37 | Re: Trying to add a type modifier to user created type |
| Previous Message | dipti shah | 2010-02-18 08:53:20 | Define permissions at database level |