Re: Query Time

"Lufkin, Brad" <brad.lufkin@ngc.com> writes:
> 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?

Lots and lots and lots of dead tuples, perhaps?  How often do you vacuum
this table?  What does VACUUM VERBOSE have to say about it?

            regards, tom lane