Christopher Kings-Lynne wrote: >Doing a row count requires a sequential scan in Postgres. > >Try creating another summary table that just has one row and one column and >is an integer. > >
I have THREE summary tables derived from "stats" with different levels of aggregation. They work quite fast, But: 1) Summary tables grow too 2) There are requests which cannot be predicted, so they involve the "stats" table itself. So I am still interested in PostgreSQL's ability to deal with multimillon records tables. Best regards, Yar. ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
