We have a GUI that let user browser through the record page by page at
about 25 records a time. (Don't ask me why but we have to have this
GUI). This translates to something like
select count(*) from table <-- to give feedback about the DB size
select * from table order by date limit 25 offset 0
Heh, sounds like phpPgAdmin...I really should do something about that.
Tables seems properly indexed, with vacuum and analyze ran regularly.
Still this very basic SQLs takes up to a minute run.
Yes, COUNT(*) on a large table is always slow in PostgreSQL. Search the
mailing lists for countless discussions about it.
Chris
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq