Is there any method to keep table in memory at startup - Mailing list pgsql-hackers

From vinayj@ncst.ernet.in
Subject Is there any method to keep table in memory at startup
Date
Msg-id 1082520813.4085f4ed6b6ff@www.ncst.ernet.in
Whole thread Raw
Responses Re: Is there any method to keep table in memory at startup  ("scott.marlowe" <scott.marlowe@ihs.com>)
List 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 by date:

Previous
From: "Merlin Moncure"
Date:
Subject: Re: FW: getting a crash during initdb
Next
From: Erwin Moller
Date:
Subject: Is this possible? concatenating results from a subquery