On Tue, May 27, 2008 at 12:11:54PM +0200, Michael Meskes wrote:
> On Mon, May 26, 2008 at 07:23:24PM -0700, David Fetter wrote:
> > Right for this case. Is there some way to estimate this short of
> > a full-on materialized views implementation? I'm guessing we'd
> > need to be able to cache the transitive closure of such searches.
>
> You'd like to cache the whole closure? Or just some stats about it?
This is getting way past my knowledge. What kind of stats could be
kept?
Since WITH RECURSIVE doesn't require that any DDL be issued in
advance, we'd need some kind of infrastructure--possibly we have it
today--which could collect those statistics on DML calls.
Cheers,
David.
--
David Fetter <david@fetter.org> http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david.fetter@gmail.com
Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate
