Re: Big disappointment with Postgres

"Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote in message news:qpudnSPoRugqwdDQnZ2dnUVZ8mydnZ2d_at_bt.com...
>
> "Thomas Kellerer" <OTPXDAJCSJVU_at_spammotel.com> wrote in message
> news:8r34l6Fn40U1_at_mid.individual.net...
>>
>> I will leave this futile discussion now
>>
>
> 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.

Regards
Jonathan Lewis Received on Wed Feb 09 2011 - 11:39:16 CST