Postgres Pro
Downloads
Home   >   mailing lists

Pinning a table into memory - Mailing list pgsql-general

From David Blood
Subject Pinning a table into memory
Date
Msg-id 03a301c26bc5$a799a970$1f00a8c0@redwood
Whole thread Raw
Responses Re: Pinning a table into memory  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: pg_restore issue..
Next
From: Bruce Momjian
Date:
Subject: Re: transactions