Re: What does this mean?

From: "Albe Laurenz" <laurenz(dot)albe(at)wien(dot)gv(dot)at>
To: "Paul Tomblin *EXTERN*" <ptomblin(at)gmail(dot)com>, <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: What does this mean?
Date: 2008-07-11 06:35:57
Message-ID: D960CB61B694CF459DCFB4B0128514C2024B1143@exadv11.host.magwien.gv.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

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

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Pushker Chaubey 2008-07-11 07:44:41 Re: Timestamp without Timezone and differing client / server tzs
Previous Message Ken Johanson 2008-07-11 05:00:09 Re: Timestamp without Timezone and differing client / server tzs