Re: What does this mean?

["Paul Tomblin" <ptomblin(at)gmail(dot)com>]

On Thu, Jul 10, 2008 at 9:50 AM, Oliver Jowett <oliver(at)opencloud(dot)com> wrote:
> 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.


-- 
House: "Because it doesn't hurt here. Because I don't want to be in
pain, I don't want to be miserable."
Amber: "Well...You can't always get what you want."