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