Re: [JDBC] Cursors performance (was: Re: [PERFORM] Terrible

2004-07-09 Thread Dave Cramer
Bill, What happens if you do this in psql, also you can turn on duration logging in the backend and log the queries. dave On Fri, 2004-07-09 at 16:24, Bill Chandler wrote: > Thanks to all who have responded. I now think my > problem is not related to deleting/recreating indexes. > Somehow it is

Re: [JDBC] Cursors performance (was: Re: [PERFORM] Terrible performance

2004-07-09 Thread Kris Jurka
On Fri, 9 Jul 2004, Bill Chandler wrote: > Thanks to all who have responded. I now think my > problem is not related to deleting/recreating indexes. > Somehow it is related to JDBC cursors. It appears > that what is happening is that since I'm using > a fetch size of 5000, the command: > > F