Andrew Dunstan wrote:
Vinay Jain wrote:
You mean that I should create a static table in C program itself and
use it...if i am not wrong
Ya for the time being i am doing this thing but actually table is
bigger (around 5000 rows with 6 columns)
bigger than what?
also this table is also
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
Andrew Dunstan wrote:
Vinay Jain said:
Andrew Dunstan wrote:
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
Tom Lane wrote:
Vinay Jain [EMAIL PROTECTED] writes:
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.
Hm, possibly you weren't using the same character set encoding
psql is exited the connection is closed...
When we start psql it makes connection with database is correct...
but not from program so have to Make SPI connection...
Andrew Hammond wrote:
Vinay Jain wrote:
Hi
thanx and sorry that I asked such a simple question in
postgres-hackers list
Tom Lane wrote:
Vinay Jain [EMAIL PROTECTED] 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
Andrew Dunstan wrote:
Vinay Jain said:
hi
ya function is declared immutable and strict... also made btree
index..
The docs state this about immutable functions:
IMMUTABLE indicates that the function always returns the same result when
given the same argument values; that is, it does
to database
regards
Vinay
Andrew Hammond wrote:
Vinay Jain wrote:
Hi
thank you for such a useful information...
but actually in my case if i keep table in disk it significantly
degrades performance and even for a table of 10 rows it takes 1-2
minutes I think u r not beliving it ! am i right
Hi
thank you for such a useful information...
but actually in my case if i keep table in disk it significantly
degrades performance and even for a table of 10 rows it takes 1-2
minutes I think u r not beliving it ! am i right
for example
I create a table in which i use my customized data