Re: Can Postgres use an INDEX over an OR? - Mailing list pgsql-performance

From Віталій Тимчишин
Subject Re: Can Postgres use an INDEX over an OR?
Date
Msg-id 331e40660907270559x1530c562pe4b55a681a6639b4@mail.gmail.com
Whole thread Raw
In response to Re: Can Postgres use an INDEX over an OR?  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-performance


27 липня 2009 р. 15:02 Robert Haas <robertmhaas@gmail.com> написав:

The problem, though, is that it won't ALWAYS be right to implement OR
using UNION, so you have to have some way of deciding which is better.

That's easy - you propose both ways to planner and it's up to it to decide. Yes, it can decide wrong way, but we are returning to statistics problem. At least one can tune costs and enable_ settings. Now one have to rewrite query that may be not possible/too complex.

pgsql-performance by date:

Previous
From: Robert Haas
Date:
Subject: Re: Can Postgres use an INDEX over an OR?
Next
From: Scott Marlowe
Date:
Subject: Re: More speed counting rows