Postgres Pro
Downloads
Home   >   mailing lists

Re: Unions and where optimisation - Mailing list pgsql-performance

From Boris Klug
Subject Re: Unions and where optimisation
Date
Msg-id 200301081713.00786.boris.klug@control.de
Whole thread Raw
In response to Re: Unions and where optimisation  ("Michael Paesold" <mpaesold@gmx.at>)
List pgsql-performance
Tree view 
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

pgsql-performance by date:

Previous
From: "Michael Paesold"
Date:
Subject: Re: Unions and where optimisation
Next
From: Tom Lane
Date:
Subject: Re: [SQL] 7.3.1 index use / performance