Postgres Pro
Downloads
Home   >   mailing lists

Multiple buffer cache? - Mailing list pgsql-general

From Alexei Vladishev
Subject Multiple buffer cache?
Date
Msg-id 4B6C9079.7050602@zabbix.com
Whole thread Raw
Responses Re: Multiple buffer cache?  ("Bret S. Lambert" <bret.lambert@gmail.com>)
Re: Multiple buffer cache?  (Greg Smith <greg@2ndquadrant.com>)
List pgsql-general
Tree view 
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.

Is it possible?

Thanks for any hints!

Alexei

pgsql-general by date:

Previous
From: Josh Kupershmidt
Date:
Subject: Re: Understanding pg_stat_user_indexes
Next
From: "Bret S. Lambert"
Date:
Subject: Re: Multiple buffer cache?