Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group