Re: User Defined Functions/AM's inherently slow?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Eric Ridge <ebr(at)tcdi(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: User Defined Functions/AM's inherently slow?
Date: 2004-01-18 04:27:56
Message-ID: 1917.1074400076@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Eric Ridge <ebr(at)tcdi(dot)com> writes:
> costestimate: {
> PG_RETURN_VOID();
> }

This at least needs to set some values into the output parameters ---
zeroes are okay, not setting them at all isn't. I'm surprised the
planner doesn't go nuts. It looks from your EXPLAIN results like
the values are coming up zero anyway, but seeing that cost_index()
doesn't do anything to initialize those local variables, I'd expect
fairly unpredictable behavior.

The other stubs look fine on quick review.

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2004-01-18 04:33:20 Re: User Defined Functions/AM's inherently slow?
Previous Message Eric Ridge 2004-01-18 04:06:31 Re: User Defined Functions/AM's inherently slow?