Re: [JDBC] What does this mean?

Paul Tomblin wrote:
> >> What does it mean when your process is stuck in the following:
> >
> > It's waiting for a query result.
>
> Yeah, but this is a very small query on a very small table. The query
> in question is
>
> "SELECT " + columns +
> "FROM venue " +
> "WHERE venueid = ?");
>
> where the table "venue" has 15 rows in it, and it's indexed
> on venueid.
>
> Hmmm. Looks like something isn't getting committed before
> the nightly vacuum.

I'd trace on the server to see what's going on.

What happens if you run the query in psql?

If you thing that there is a problem with VACUUM, try to
run "VACUUM VERBOSE venue" in psql and see what it says.

Yours,
Laurenz Albe

--
Sent via pgsql-jdbc mailing list (pgsql-jdbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-jdbc