Re: Does FILTER in SEQSCAN short-circuit AND?

From: Craig James <craig_james(at)emolecules(dot)com>
To: Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Does FILTER in SEQSCAN short-circuit AND?
Date: 2010-05-27 21:44:19
Message-ID: 4BFEE7B3.7080608@emolecules.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On 5/27/10 2:28 PM, Kevin Grittner wrote:
> Craig James<craig_james(at)emolecules(dot)com> wrote:
>
>> It would be nice if Postgres had a way to assign a cost to every
>> function.
>
> The COST clause of CREATE FUNCTION doesn't do what you want?
>
> http://www.postgresql.org/docs/8.4/interactive/sql-createfunction.html

Cool ... I must have missed it when this feature was added. Nice!

Craig

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Krzysztof Nienartowicz 2010-05-27 23:04:17 Re: Query causing explosion of temp space with join involving partitioning
Previous Message Bryan Hinton 2010-05-27 21:40:12 Re: Random Page Cost and Planner