Re: Improving count(*) - Mailing list pgsql-hackers

From Josh Berkus
Subject Re: Improving count(*)
Date
Msg-id 200511181722.34809.josh@agliodbs.com
Whole thread Raw
In response to Re: Improving count(*)  (Alvaro Herrera <alvherre@commandprompt.com>)
Responses Materialized views (Was Re: Improving count(*))  (Heikki Linnakangas <hlinnaka@iki.fi>)
List pgsql-hackers
Alvaro,

> I guess there must be a query-rewriting mechanism for implementing
> materialized views.  With that in place we may be able to implement this
> other thing ...  Is anybody working on materialized views?

I have a bundle of academic code designed to do exactly this, if any hacker
wants to take on the task of getting it into production shape.

--
Josh Berkus
Aglio Database Solutions
San Francisco


pgsql-hackers by date:

Previous
From: mark@mark.mielke.cc
Date:
Subject: Re: Improving count(*)
Next
From: Grzegorz Jaskiewicz
Date:
Subject: Re: order by, for custom types