Re: Function Stats WAS: Passing arguments to views

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

In response to

Responses

Browse pgsql-hackers by date

  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