On Tue, Apr 10, 2012 at 7:27 AM, Heikki Linnakangas <heikki.linnakan...@enterprisedb.com> wrote: > I think the way we'd speed up COUNT(*) further would be to implement > materialized views. Then you could define a materialized view on COUNT(*), > and essentially get a row counter similar to MyISAM. I think it's fair to > mark this as done.
If only because it comes up so frequently it would be good to have this noted in the TODO, either under materialized views or as a pointer to them. A good materialized views implementation including automatically determining what delta data to keep sure would be nice to have. -- greg -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
