Postgres Pro
Downloads
Home   >   mailing lists

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

From Atri Sharma
Subject Re: Feature request: Optimizer improvement
Date
Msg-id CAOeZVicSnXyys5uZ62Q0HbDpHgZ1e=5GjZWO5PSkGkt+YW_+=w@mail.gmail.com
Whole thread Raw
In response to Re: Feature request: Optimizer improvement  (Jim Nasby <jim@nasby.net>)
List pgsql-hackers
Tree view


On Friday, November 1, 2013, Jim Nasby wrote:
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…?

+1

It's sounds straight logical 


--
Regards,
 
Atri
l'apprenant

pgsql-hackers by date:

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