Re: What does this mean? - Mailing list pgsql-jdbc

On Thu, Jul 10, 2008 at 9:50 AM, Oliver Jowett <oliver@opencloud.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."