Fwd: Re: [PERFORM] postgresql.conf

2003-08-05 Thread Hilary Forbes
Scott For example, a dedicated database for a webserver would be tuned differently from a server that was running both the webserver and the database on the same machine. This is the situation I'm having fun and games with so I'd be very interested. (Client has made the mistake of putting Mr

Re: [PERFORM] Odd performance results - more info

2003-08-05 Thread Joe Conway
Medora Schauer wrote: I would greatly appreciate it if someone could run this code in their environment and let me know if you get results similiar to mine. The INT test results in execution times of 11 - 50+ secs increasing each time the test is run. The FLOAT test execution times are

Re: [PERFORM] Moving postgresql.conf tunables into 2003...

2003-08-05 Thread Sean Chittenden
is some other problem that needs to be solved. (I'd wonder about index correlation myself; we know that that equation is pretty bogus.) Could be. I had him create a multi-column index on the date and a non-unique highly redundant id. Tom has already suspected index correlation to be

Re: [PERFORM] Some vacuum tuning help

2003-08-05 Thread Matthew T. O'Connor
On Tue, 2003-08-05 at 17:40, Christopher Browne wrote: Unfortunately, a configurable-via-tables pg_autovacuum is also going to be quite different from the current unconfigurable version. true, however I would like to preserve the unconfigured functionality so that it can be run against a