Re: generalizing the planner knobs - Mailing list pgsql-hackers

From Rod Taylor
Subject Re: generalizing the planner knobs
Date
Msg-id 1133536807.12218.168.camel@home
Whole thread Raw
In response to Re: generalizing the planner knobs  (Greg Stark <gsstark@mit.edu>)
Responses Re: generalizing the planner knobs  (Greg Stark <gsstark@mit.edu>)
List pgsql-hackers
> In the extreme, no amount of added intelligence in the optimizer is going to
> help it come up with any sane selectivity estimate for something like 
> 
>   WHERE radius_authenticate(user) = 'OK'

Why not?

The missing capability in this case is to be able to provide or generate
(self learning?) statistics for a function that describe a typical
result and the cost of getting that result.
-- 



pgsql-hackers by date:

Previous
From: "Cristian Prieto"
Date:
Subject: Re: Graphics in postgress using GTK
Next
From: Jaime Casanova
Date:
Subject: Re: Graphics in postgress using GTK