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 ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
