| From: | Greg Stark <stark(at)mit(dot)edu> |
|---|---|
| To: | Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com> |
| Cc: | Jeff Janes <jeff(dot)janes(at)gmail(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: To Do wiki |
| Date: | 2012-04-10 15:18:19 |
| Message-ID: | CAM-w4HO+JyTtZqL0Hx3JC00qELZJqCLNFVe83z8jsVYPbMvH8A@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Tue, Apr 10, 2012 at 7:27 AM, Heikki Linnakangas
<heikki(dot)linnakangas(at)enterprisedb(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Geoghegan | 2012-04-10 15:24:35 | Re: Last gasp |
| Previous Message | Merlin Moncure | 2012-04-10 15:10:58 | Re: [JDBC] Regarding GSoc Application |