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

2003-11-03 Thread Ang Chin Han
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

Re: [HACKERS] massive quotes?

2003-09-12 Thread Ang Chin Han
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

Re: [HACKERS] reprise on Linux overcommit handling

2003-07-22 Thread Ang Chin Han
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?

2003-07-15 Thread Ang Chin Han
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.