[HACKERS] client performance v.s. server statistics

shared memory for the records, thus provides extremely realtime access (of course sacrifice some other features such as consistency). Best regards, Han

Re: [HACKERS] client performance v.s. server statistics

. There are other index based queries, which are of course much faster, but still result in similar ten-fold of time gap between client side and server side statistics. I am thinking of non-kernel involved client interface, is there such an option, or do I have to develop one from scratch? Best regards, Han

Re: [HACKERS] Experimental patch for inter-page delay in VACUUM

Christopher Browne wrote: Centuries ago, Nostradamus foresaw when Stephen [EMAIL PROTECTED] would write: As it turns out. With vacuum_page_delay = 0, VACUUM took 1m20s (80s) to complete, with vacuum_page_delay = 1 and vacuum_page_delay = 10, both VACUUMs completed in 18m3s (1080 sec). A factor of

[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

Re: [HACKERS] massive quotes?

Tilo Schwarz wrote: What about the Python approach: The literal text is enclosed either in a pair of three single quotes or three double quotes. So you can do (e.g. in the python shell) It'll only make plpyhon functions harder to write, if you need to use longstring quoting INSIDE your plpython

[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

Re: [HACKERS] reprise on Linux overcommit handling

Andrew Dunstan wrote: Rather than give bad advice, it might be better to advise users (1) to run Pg on machines that are likely to be stable and not run into OOM situations, and (2) to check with their vendors about proper overcommit handling. Would it be possible (or trivial?) to write a small C

Re: [HACKERS] Hyperthreading or not?

Mendola Gaetano wrote: Hi all, we are going to move our production postgres box ( on Linux ) in a new machine, I'm wondering if I shall leave the Hyperthreading feature on or disable it. Anyone have experience on this? Just FYI. We turned Hyperthreading off for our production *dual* Xeon box.

Re: [HACKERS] updateable cursors visibility

lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED]) Regards! Han [EMAIL PROTECTED] 2003-03-28 ---(end of broadcast)--- TIP 2: you can get off all lists

[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