Re: What does this mean?

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."