"A. Kretschmer" <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate