Re: [PERFORM] COPY vs INSERT

On Wed, 4 May 2005, Mischa Sandberg wrote: Quoting Kris Jurka [EMAIL PROTECTED]: Not true. A client may send any number of Bind/Execute messages on a prepared statement before a Sync message. Hunh. Interesting optimization in the JDBC driver. I gather it is sending a string of

[PERFORM] Bad choice of query plan from PG 7.3.6 to PG 7.3.9 part 1

Hi I'm currently experiencing problems with long query execution times. What I believe makes these problems particularly interesting is the difference in execution plans between our test server running PostGreSQL 7.3.6 and our production server running PostGreSQL 7.3.9. The test server is an

Re: [PERFORM] Bad choice of query plan from PG 7.3.6 to PG 7.3.9 part 1

Jona [EMAIL PROTECTED] writes: I'm currently experiencing problems with long query execution times. What I believe makes these problems particularly interesting is the difference in execution plans between our test server running PostGreSQL 7.3.6 and our production server running PostGreSQL

Re: [PERFORM] Table stats

Should there not be at least one Index Scan showing in the stats? not if there was a table scan ---(end of broadcast)--- TIP 8: explain analyze is your friend