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

Tom Lane wrote:

>Vinay Jain <vinayj@sarathi.ncst.ernet.in> writes:
>  
>
>>Which takes a lot of time the reason is that in every indchar_lt 
>>function call SPI connection is made and destroyed...
>>    
>>
>
>I cannot imagine how you'd think that that would be practical from a
>performance standpoint.
>
>  
>
>>Here is the problem which i found in postgresql...
>>after setting collating sequence in proper way(i.e. C) the order was 
>>on basis of unicode values...but in Hindi Language some of combined 
>>unicode values makes a single character
>>similarly length is not appropriate for these reasons & hence 
>>substring operations
>>    
>>
>
>Why don't you just use a Hindi locale?  The infrastructure should all be
>there already for you.
>
>            regards, tom lane
>
Hi
Not actually even in Hindi Locale the output was incorrect..i.e. sort 
order was wrong
and also length and substring operations
which are not based on syllables.

>
>  
>