On Tue, Apr 10, 2012 at 7:27 AM, Heikki Linnakangas
<heikki.linnakangas@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