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