Not too many releases ago, there were several columns in pg_proc that
were intended to support estimation of the runtime cost and number of
result rows of set-returning functions. I believe in fact that these
were the remains of Joe Hellerstein's thesis on expensive-function
evaluation, and are ex
On Fri, Apr 08, 2005 at 04:04:27PM -0700, Josh Berkus wrote:
> My solution would be a lot simpler, since we could simply populate
> pg_proc.proestrows with "1000" by default if not changed by the DBA. In an
> even better world, we could tie it to a table, saying that, for example,
> proestrows
Alvaro, Michael,
> > About a month ago I mentioned that I'd find that useful. In a
> > followup, Christopher Kings-Lynne brought up the idea of a GUC
> > variable that could give hints about the expected row count.
>
> That seems pretty limited ... what happens if the query contains more
> that o
On Fri, Apr 08, 2005 at 04:38:20PM -0600, Michael Fuhr wrote:
> On Fri, Apr 08, 2005 at 03:15:50PM -0700, Josh Berkus wrote:
> >
> > 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
On Fri, Apr 08, 2005 at 03:15:50PM -0700, Josh Berkus wrote:
>
> 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 s
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
Jeff,
> Specifically is the performance of
> gigE good enough to allow postgres to perform under load with an NFS
> mounted DATA dir? Are there other problems I haven't thought about? Any
> input would be greatly appreciated.
The big problem with NFS-mounted data is that NFS is designed to be
