Re: Is there any method to keep table in memory at startup

Andrew Dunstan wrote:

>Vinay Jain said:
>
>
>>Andrew Dunstan wrote:
>>
>>
>>
>>>uh ... maybe you need to look in your C manual about the effect of a
>>>"static" declaration. The object will be created once.
>>>
>>>
>>>
>>yup I know the effect of Static but this is also fact that when
>>program terminates and restarts object will be created again...(not
>>persistant)..
>>
>>
>>
>
>you can have it preloaded and persistent to the end of the server run, see
>http://www.postgresql.org/docs/current/static/runtime-config.html#RUNTIME-
>CONFIG-RESOURCE
>
>
>
>
>>one thing strikes in my mind is that indchar_lt is function in shared
>>object file indchar.so.....if this file is not unloaded during Order by
>> call than this static defination can work for me..
>>Not sure but I think this file is loaded each time indchar_lt is called
>> in order by clause...
>>
>>
>>
>
>If course it is not loaded each time. That would be insane. If not
>preloaded it is loaded when first called in each process, and then kept.
>It is never unloaded (except by the termination of the process that loaded
>it).
>
>It seems you have been laboring under a misapprehension.
>
If this is the case than I can make connection to data base in starting
of indchar.so file and close connection at end of it and it should work....
bingo!!
it would solve my problem

>
>cheers
>
>andrew
>
>thanx
>
>Vinay Jain
>---------------------------(end of broadcast)---------------------------
>TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
>
>
>