[HACKERS] why postgresql is so slow?

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)--- TIP 7: don't forget to increase

[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 appropriate

[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)--- TIP 4: Don't

[HACKERS] inquiry

(querytree_listquerytree){ //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

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, I have read the source code of postgres.c

[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?

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 ---(end

[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

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 unregister command