Query Time - Mailing list pgsql-jdbc

From Lufkin, Brad
Subject Query Time
Date
Msg-id 0E253E40DC78F4499CEDDE9223099F430706B7CB@xcgva040.northgrum.com
Whole thread Raw
Responses Re: Query Time
Re: Query Time
List pgsql-jdbc
I'm running the following query:

    SELECT * FROM someTable LIMIT 20

I turned on explain analyze (tip #8!) and was told that the query plan was
sequential (no surprise there) with an estimated cost of between 0.00 and
1.07. Surprisingly, the actual time was around 90000 msec (or one-and-a-half
minutes). What's going on?

pgsql-jdbc by date:

Previous
From: Arturo Pérez
Date:
Subject: Fwd: [HACKERS] 7.4 LOG: invalid message length
Next
From: "scott.marlowe"
Date:
Subject: Re: Query Time