Re: 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