Re: Unions and where optimisation

From: Boris Klug <boris(dot)klug(at)control(dot)de>
To: "Michael Paesold" <mpaesold(at)gmx(dot)at>, "Tomasz Myrta" <jasiek(at)klaster(dot)net>, "Hannu Krosing" <hannu(at)tm(dot)ee>
Cc: <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Unions and where optimisation
Date: 2003-01-08 16:13:00
Message-ID: 200301081713.00786.boris.klug@control.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Hello!

> As far as I know, this has first been "fixed" in 7.3. I think it was Tom
> who improved the optimizer to push the where clause into the selects of a
> union view. I've done a test...

Yes, I installed 7.3 and it works fine there. I think we will upgrade to 7.3.1
our development system soon.

Thank you!

--
Dipl. Inform. Boris Klug, control IT GmbH, Germany

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Hannu Krosing 2003-01-08 16:49:20 Re: Unions and where optimisation
Previous Message Hannu Krosing 2003-01-08 16:02:15 Re: Unions and where optimisation