Re: shared_buffers/effective_cache_size on 96GB server - Mailing list pgsql-performance

From Claudio Freire
Subject Re: shared_buffers/effective_cache_size on 96GB server
Date
Msg-id CAGTBQpbR35EDtEBcUepJCzU03px8=rHZXUvwCCbKnadFtyDfTA@mail.gmail.com
Whole thread Raw
In response to Re: shared_buffers/effective_cache_size on 96GB server  (Shaun Thomas <sthomas@optionshouse.com>)
List pgsql-performance
On Wed, Oct 10, 2012 at 3:18 PM, Shaun Thomas <sthomas@optionshouse.com> wrote:
>> Why does nobody every mention that concurrent access has to be taken
>> into account?
>
>
> That's actually a good point. But if you have one giant database, the
> overlap of which tables are being accessed by various sessions is going to
> be immense.

That's why I said "several huge indices". If regularly accessed
indices are separate, and big, it means they don't overlap nor do they
fit in any cache.


pgsql-performance by date:

Previous
From: Shaun Thomas
Date:
Subject: Re: shared_buffers/effective_cache_size on 96GB server
Next
From: Shane Hathaway
Date:
Subject: Re: Ways to speed up ts_rank