Re: Multiple buffer cache?

On Fri, Feb 05, 2010 at 11:41:13PM +0200, Alexei Vladishev wrote:
> Greetings,
>
> Is there a way of configuring PostgreSQL so that one specific table would
> use, say, 4GB of buffer cache while other tables would use the rest?
>
> I would like to keep the table and its indexes always in "hot"
> state, so that
> other queries won't pollute this part of the buffer cache. It would ensure
> reliable performance and much less disk IOPS working with the table.

Fiddling with the buffer cache like that would require some sort of
OS support, if I'm not mistaken in what you're asking for.

And then, even if the support is there, you'd need to outline exactly
how you're planning on pushing this button.

Specifically, what's your usage pattern that would make this a
win for you?

If the table and its indexes can already fit into the buffer cache,
and it's as commonly accessed as you think it is, the OS should
probably have it cached anyway.

>
> Is it possible?
>
> Thanks for any hints!
>
> Alexei
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general