Re: To Do wiki - Mailing list pgsql-hackers

From Greg Stark
Subject Re: To Do wiki
Date
Msg-id CAM-w4HO+JyTtZqL0Hx3JC00qELZJqCLNFVe83z8jsVYPbMvH8A@mail.gmail.com
Whole thread Raw
In response to Re: To Do wiki  (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>)
List pgsql-hackers
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


pgsql-hackers by date:

Previous
From: Merlin Moncure
Date:
Subject: Re: [JDBC] Regarding GSoc Application
Next
From: Peter Geoghegan
Date:
Subject: Re: Last gasp