Is there any method to keep table in memory at startup

Поиск
Список
Период
Сортировка
От vinayj@ncst.ernet.in
Тема Is there any method to keep table in memory at startup
Дата
Msg-id 1082520813.4085f4ed6b6ff@www.ncst.ernet.in
обсуждение исходный текст
Ответы Re: Is there any method to keep table in memory at startup  ("scott.marlowe" <scott.marlowe@ihs.com>)
Список pgsql-hackers
Hi
I am working on a project in postgres..in which i designed customized data type
and operations on it.it requires a look up table..
I have three options regarding this table...
1. Every time a query is executed it creates table assigns values and after
execution destroys it...which is overhead..

2. store table on disk in database and access it whenever required but it
degrades the performance

3. whenever psql starts it can load the table in memory from database which is
efficient way to do

but i don't know how to load table in memory when psql starts up ...
please guide me..
thanks in advance
regards
vinay

---------------------------------------------------------------
This mail is sent through IMP: http://horde.org/imp/
Used as the Webmail Interface at C-DAC, Mumbai: http://www.ncst.ernet.in



В списке pgsql-hackers по дате отправления:

Предыдущее
От: "Merlin Moncure"
Дата:
Сообщение: Re: FW: getting a crash during initdb
Следующее
От: Erwin Moller
Дата:
Сообщение: Is this possible? concatenating results from a subquery