Pinning a table into memory

David Blood <david@matraex.com>

From: "David Blood" <david@matraex.com>
To: <pgsql-general@postgresql.org>
Date: 2002-10-04T16:46:57Z
Lists: pgsql-hackers, pgsql-performance
In Oracle you can Pin large objects into memory to prevent frequent
reloads. Is there anyway to do this with Postgres?  It appears that some
of our tables that get hit a lot may get kicked out of memory when we
access some of our huge tables. Then they have to wait for I/O to get
loaded back in. 


David Blood
Matraex, Inc