Re: pre-loading a user table. - Mailing list pgsql-hackers

From Zeugswetter Andreas SB SD
Subject Re: pre-loading a user table.
Date
Msg-id 46C15C39FEB2C44BA555E356FBCD6FA40184D051@m0114.s-mxs.net
Whole thread Raw
In response to pre-loading a user table.  (Ana Cerejo <ana.cerejo@yale.edu>)
List pgsql-hackers
> Why do you think it useful to preload something during InitPostgres,
> anyway?  Any heavily used table will certainly be present in shared
> buffers already, and even more surely present in kernel buffers.

And if you really want it preloaded you can issue dummy selects
with a client right after startup. I really think locking a table into
memory is a worthless feature if a good buffer manager is at work.

Andreas


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Inconsistent behavior on Array & Is Null?
Next
From: Greg Stark
Date:
Subject: Re: Inconsistent behavior on Array & Is Null?