Re: Postgres 8.2 and setFetchSize

[Oliver Jowett <oliver(at)opencloud(dot)com>]

Frédéric Houbie wrote:

>         st.setFetchSize(Integer.parseInt(args[0]));
>         System.out.println("FetchSize : " + st.getFetchSize());
> 	  String q="SELECT a FROM SValues WHERE  Name = 'title'";

> It always take the same time (long time) whatever value I pass to this code for the FetchSize.

Fetch size does not directly affect query speed, it affects the number 
of results the driver retrieves at once. If you've got a query that is 
slow and takes a long time to return any results at all, changing the 
fetchsize isn't going to help.

Since it sounds like you are getting quite different results on two 
different server installations I would guess that the two databases are 
not actually identical. Perhaps one is using an index but the other 
isn't? Try the queries via psql, use EXPLAIN, etc.

-O