| From: | vinayj(at)ncst(dot)ernet(dot)in |
|---|---|
| To: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Is there any method to keep table in memory at startup |
| Date: | 2004-04-21 04:13:33 |
| Message-ID: | 1082520813.4085f4ed6b6ff@www.ncst.ernet.in |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2004-04-21 04:38:52 | Re: pg_autovacuum crashes when query fails for temp tables |
| Previous Message | Shalu Gupta | 2004-04-21 04:08:16 | TPC H data |