[GENERAL] Idle Connection force-close ?

2004-02-12 Thread John Gibson
Hi, all. We are running PostgreSQL 7.2.2 (7.4.1 in a few weeks). We have a pesky legacy application which periodically leaves open idle connections. (I know... fix the application). In the short term, I would like to find out if the database engine has a time-out configuration option for i

Re: [GENERAL] Quad Xeon vs. Dual Itanium

2004-02-09 Thread John Gibson
Doug McNaught wrote: John Gibson <[EMAIL PROTECTED]> writes: Assuming similar memory and disk sub-systems, I am considering a Quad Xeon system vs. a Dual Itanium for PostgreSQL. I believe that the PostgreSQL code is written for 32 bit and not optimized for the 64 bit Itanium cpu. That

[GENERAL] Storing Snapshot Data

2003-12-11 Thread John Gibson
Hi, all. I have a table which is continually updated with the latest totals. I would like to take snapshots of some of the data in that table and store it in a second table to run statistics on it later. What might some ways of doing this be? Illustrative (I hope) example using fruit-qty-on-

Re: [GENERAL] [NOVICE] PostgreSQL Training

2003-12-10 Thread John Gibson
"Linux" training is not standardized by any measure either. Lots of companies and "institutions" offer their own training courses. Some of these grow to be fairly well recognized and are offered in similar form repeatedly in different locations, but that is not "standardized" in the sense y

[GENERAL] Turning on/off debugging

2003-12-08 Thread John Gibson
Hi, all. Re: version 7.2.2 I modified the postgresql.conf file as below and got "really neat" debugging turned on. :) pg_ctl reload -D Unfortunately after I was done, I wanted to turn it off again. I commented out the lines and ran the "reload" again. This did not have any effect. So, I