Re: What does this mean?

["Albe Laurenz" <laurenz(dot)albe(at)wien(dot)gv(dot)at>]

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