Re: Big disappointment with Postgres
Date: Wed, 9 Feb 2011 16:17:08 -0800 (PST)
Message-ID: <b66d2b04-78d0-472c-ac75-f9aa5d6ce557_at_1g2000pro.googlegroups.com>
On Feb 10, 4:39 am, "Jonathan Lewis" <jonat..._at_jlcomp.demon.co.uk> wrote:
>
> > Before you go, could you tell us what you would have to do as a DBA to
> > ensure that Postgres could calculate the correct selectivity on something
> > as simple as:
>
> > select *
> > from orders
> > where
> > date_delivered > date_placed + 72 hours
> > ;
>
> I don't suppose there's anyone from the Postgress optimizer programmers
> around still to supply an answer to this question.
> If this one is too easy, I'm ready with several that gradually get harder.
>
Don't get your hopes too high, you know that's just "dba nonsense":
anything out of their mindset can't possibly exist or have any
relevance.
Small details like large production environments are "impure" and only
"pollute the thought process"...
Received on Wed Feb 09 2011 - 18:17:08 CST