From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | josh(at)agliodbs(dot)com |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: Function Stats WAS: Passing arguments to views |
Date: | 2006-02-03 19:32:53 |
Message-ID: | 28425.1138995173@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Josh Berkus <josh(at)agliodbs(dot)com> writes:
> What I'd like to do is implement the constant method for 8.2, and work on
> doing the S() method later on. Does that make sense?
I'm not thrilled with putting in a stopgap that we will have to support
forever. The constant method is *clearly* inadequate for many (probably
most IMHO) practical cases. Where do you see it being of use?
W.R.T. the estimator function method, the concern about recursion seems
misplaced. Such an estimator presumably wouldn't invoke the associated
function itself. I'm more concerned about coming up with a usable API
for such things. Our existing mechanisms for estimating operator
selectivities require access to internal planner data structures, which
makes it pretty much impossible to write them in anything but C. We'd
need something cleaner to have a feature I'd want to export for general
use.
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Josh Berkus | 2006-02-03 19:49:06 | Re: Function Stats WAS: Passing arguments to views |
Previous Message | Daniel Schuchardt | 2006-02-03 19:25:48 | Re: Error working with Temporary Sequences in plpgsql in 8.1 (8.0 |