Re: slow query

"A. Kretschmer" <andreas.kretschmer@schollglas.com> writes:
> am  Thu, dem 05.04.2007, um  1:27:25 -0400 mailte Tom Lane folgendes:
>> I'm betting the problem is poor vacuuming practice leading to lots of
>> dead space.  There's no way it takes 22 sec to read 10 rows if the
>> table is reasonably dense.

> This was my first thought, but:

> ,----[  Quote  ]
> | I've tried
> | vacuuming this table many time
> `----

[ shrug... ]  If the damage is already done, lazy VACUUM won't fix it.
        regards, tom lane