Re: pre-loading a user table.

Поиск
Список
Период
Сортировка
От Zeugswetter Andreas SB SD
Тема Re: pre-loading a user table.
Дата
Msg-id 46C15C39FEB2C44BA555E356FBCD6FA40184D051@m0114.s-mxs.net
обсуждение исходный текст
Ответ на pre-loading a user table.  (Ana Cerejo <ana.cerejo@yale.edu>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Inconsistent behavior on Array & Is Null?
Следующее
От: Greg Stark
Дата:
Сообщение: Re: Inconsistent behavior on Array & Is Null?