Re: Feature request: Optimizer improvement - Mailing list pgsql-hackers

From Jim Nasby
Subject Re: Feature request: Optimizer improvement
Date
Msg-id CB8882C4-C499-4203-B3E2-F6D1B8B915B5@nasby.net
Whole thread Raw
In response to Re: Feature request: Optimizer improvement  (Kevin Grittner <kgrittn@ymail.com>)
Responses Re: Feature request: Optimizer improvement  (Atri Sharma <atri.jiit@gmail.com>)
Re: Feature request: Optimizer improvement  (David Johnston <polobo@yahoo.com>)
List pgsql-hackers
On Oct 31, 2013, at 2:57 PM, Kevin Grittner <kgrittn@ymail.com> wrote:
Joe Love <joe@primoweb.com> wrote:

In postgres 9.2 I have a function that is relatively expensive.

What did you specify in the COST clause on the CREATE FUNCTION
statement?

Should that really matter in this case? ISTM we should always handle LIMIT before moving on to the SELECT clause…?

pgsql-hackers by date:

Previous
From: Jim Nasby
Date:
Subject: Re: [BUGS] BUG #8573: int4range memory consumption
Next
From: Tom Lane
Date:
Subject: Re: Handle LIMIT/OFFSET before select clause (was: Feature request: optimizer improvement)