Functionscan estimates - Mailing list pgsql-performance

From Josh Berkus
Subject Functionscan estimates
Date
Msg-id 200504081515.50340.josh@agliodbs.com
Whole thread Raw
Responses Re: Functionscan estimates
List pgsql-performance
Folks,

I'm wondering if it might be useful to be able to add estimated selectivity to
a function definition for purposes of query estimation.  Currently function
scans automatically return a flat default 1000 estimated rows.   It seems
like the DBA ought to be able to ALTER FUNCTION and give it a row estimate
for planning purposes.

Thoughts?

--
--Josh

Josh Berkus
Aglio Database Solutions
San Francisco

pgsql-performance by date:

Previous
From: Josh Berkus
Date:
Subject: Re: [sfpug] DATA directory on network attached storage
Next
From: Michael Fuhr
Date:
Subject: Re: Functionscan estimates