| From: | Claudio Freire <klaussfreire(at)gmail(dot)com> |
|---|---|
| To: | Strahinja Kustudić <strahinjak(at)nordeus(dot)com> |
| Cc: | Jeff Janes <jeff(dot)janes(at)gmail(dot)com>, pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: shared_buffers/effective_cache_size on 96GB server |
| Date: | 2012-10-10 20:48:18 |
| Message-ID: | CAGTBQpaFon0fKMk6ikdpAf0jKfHrNh+caNunKnJ30jozX2K17w@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On Wed, Oct 10, 2012 at 5:12 PM, Strahinja Kustudić
<strahinjak(at)nordeus(dot)com> wrote:
> @Claudio So you are basically saying that if I have set effective_cache_size
> to 10GB and I have 10 concurrent processes which are using 10 different
> indices which are for example 2GB, it would be better to set the
> effective_cache size to 1GB? Since if I leave it at 10GB each running
> process query planner will think the whole index is in cache and that won't
> be true? Did I get that right?
Yep. You might get away with setting 2GB, if you're willing to bet
there won't be 100% concurrency. But the safest setting would be 1G.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2012-10-10 21:03:15 | Re: shared_buffers/effective_cache_size on 96GB server |
| Previous Message | Strahinja Kustudić | 2012-10-10 20:12:51 | Re: shared_buffers/effective_cache_size on 96GB server |