[HACKERS] why postgresql is so slow?

ot;selct * from table1 where id=10" in psql is much faster than that of executing "select * from table1 where id <10" in psql. why? By the way I'm using postgresql 7.3. Who can tell me the reason. 3x. Jinqiang Han ---(end of broadcast)

[HACKERS] win32 porting in 7.4

hi, Tom and Momjian I wonder if 7.4 will have win32 porting？ I checkout source from cvs. I only find win32 makefile for client. Jinqiang Han [EMAIL PROTECTED] 　　2003-08-05 ---(end of broadcast

[HACKERS] PITR in 7.4

hi, Tom and Momjian Is PITR also delayed to 7.5?Right? 3x Jinqiang Han [EMAIL PROTECTED] 　　2003-08-05 ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an

Re: [HACKERS] inquiry

hi,Bruce Momjian I think you are wrong. multiple query in a string, such as ""SELECT;SELECT" will invoke pg_execute_query_string twice, It won't generate two parsetree. === 2003-03-26 10:20:00 您在来信中写道：=== >Jinqiang Han wrote: >> hello, >

[HACKERS] inquiry

_list中的每个querytree){ //In what situation here will be many querytrees？ Who can tell me the reason? Thank you very much Jinqiang Han ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html

[HACKERS] inquiery

hello， what is RIR rules in Rewriter? What RIR means? Thank you very much. Jinqiang Han ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your

[HACKERS] who can help me?

system catalog. Is there any difference between them? Thanks a lot. Jinqiang Han ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

[HACKERS] about data type id

hello, Is there a function that I can get type id from type name, such as from 'text' to 25, 'int' to 23. thanks in advance. Jinqiang Han ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

[HACKERS] about table function

hello, Joe Conway. it seems the crosstab function you write in contrib/tablefunc can't work. it saids that A column definition list is required for functions returning RECORD. How can i make it work? thank you very much best regard, Jinqiang Han ---(e

[HACKERS] The document

Hello In the document of postgresql I always see such text '\ref{where_clause} '. But I wonder how can I see the graphics. In the DocBook software? Thank you in advance. Jinqiang Han  

[HACKERS] about postgresql-7.3.2 rpm

at I change the define perl 1 to 0 in spec file, It then can work properly. I wonder where to get perl5 package to make it whole? Thank you very much. Jinqiang Han ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unr