27 липня 2009 р. 15:02 Robert Haas <robertmhaas(at)gmail(dot)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.
In response to
pgsql-performance by date
|Next:||From: Scott Marlowe||Date: 2009-07-27 13:39:32|
|Subject: Re: More speed counting rows|
|Previous:||From: Robert Haas||Date: 2009-07-27 12:02:43|
|Subject: Re: Can Postgres use an INDEX over an OR?|