"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