Skip site navigation (1) Skip section navigation (2)

strange problem

From: "Gilbert, Antoine" <AGilbert(at)korem(dot)com>
To: <pgsql-jdbc(at)postgresql(dot)org>
Subject: strange problem
Date: 2006-01-25 19:51:24
Message-ID: DF58692A2DBF5440910BFE80B73D73E1019F2A4E@sqexc02.korem.local (view raw, whole thread or download thread mbox)
Lists: pgsql-jdbc


I have a single PostGIS table in PostgreSQL


This table has like 500000 records


I use the JDBC driver to only send a quick query without browsing
resultset and it take forever. For example:


Statement stmt = connection.createStatement();

ResultSet rs =stmt.executeQuery("select street from \"QCs_polyline\"");



This takes 19 sec. Does I am missing something like a configuration on
the driver? So far I was just testing PostGIS/PostgreSQL with tiny



pgsql-jdbc by date

Next:From: Kris JurkaDate: 2006-01-25 20:20:32
Subject: Re: strange problem
Previous:From: David HustaceDate: 2006-01-25 19:23:01
Subject: Re: Socket read fails

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group