Paul Langard <[EMAIL PROTECTED]> writes: > select count(id) from project > count > 9106 > 1 row(s) > Total runtime: 45,778.813 ms
Yipes. The only explanation I can think of is tremendous table bloat. What do you get from "vacuum verbose project" --- in particular, how many pages in the table? > ... the database is regularly vaccuumed. Not regularly enough, perhaps ... or else you need to increase the free space map size parameters. In any case you'll probably need to do one round of "vacuum full" to get this table back within bounds. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings