[EMAIL PROTECTED] (Gregory Stark) writes:
> "Aleksandr Vinokurov" <[EMAIL PROTECTED]> writes:
>
>> Gregory Stark wrote:
>>>
>>> What version are you running with?
>>
>> 8.0.1, sorry for missing.
>
> There have been 12 bug-fix releases since then on the 8.0 branch including
> updating timezones to r
"Aleksandr Vinokurov" <[EMAIL PROTECTED]> writes:
> Gregory Stark wrote:
>>
>> What version are you running with?
>
> 8.0.1, sorry for missing.
There have been 12 bug-fix releases since then on the 8.0 branch including
updating timezones to reflect the new daylight saving time rules for North
Am
Alvaro Herrera wrote:
Aleksandr Vinokurov escribió:
Tom Lane wrote:
When criticizing planner deficiencies, it's considered polite to use
something that's less than two major releases back ;-)
Sorry, it was blown out from my head at the end of composing: my version is
8.0.1, not so old, IMHO.
Aleksandr Vinokurov escribió:
> Tom Lane wrote:
>> When criticizing planner deficiencies, it's considered polite to use
>> something that's less than two major releases back ;-)
>
> Sorry, it was blown out from my head at the end of composing: my version is
> 8.0.1, not so old, IMHO.
It _is_ qui
Gregory Stark wrote:
"Aleksandr Vinokurov" <[EMAIL PROTECTED]> writes:
And that is its plan (attached one is the same, but with costs):
-<
Merge Left Join
Merge Cond: ("outer".name = "inner".name)
-> Sort
Sort K
Tom Lane wrote:
Aleksandr Vinokurov <[EMAIL PROTECTED]> writes:
Trying to get an extra time savings in my query, I stopped at an unusual
doggedness of the planner.
Merge Left Join
Merge Cond: ("outer".name = "inner".name)
-> Sort
Sort Key: log.name
-> Seq Scan
"Aleksandr Vinokurov" <[EMAIL PROTECTED]> writes:
> And that is its plan (attached one is the same, but with costs):
>
>>-<
> Merge Left Join
>Merge Cond: ("outer".name = "inner".name)
>-> Sort
> Sort Key: log.name
Aleksandr Vinokurov <[EMAIL PROTECTED]> writes:
> Trying to get an extra time savings in my query, I stopped at an unusual
> doggedness of the planner.
> Merge Left Join
> Merge Cond: ("outer".name = "inner".name)
> -> Sort
> Sort Key: log.name
> -> Seq Scan on log
Hello all,
Trying to get an extra time savings in my query, I stopped at an unusual
doggedness of the planner.
Here is the query:
>-<
select *
from (
select *
from "user_history"
order by name
) as uh
