Re: Plan differences - Mailing list pgsql-performance

From Anton Melser
Subject Re: Plan differences
Date
Msg-id CAKywjPrzXohDWicSN4UqY3s05xkkY0Qnv+CSxPNfCErVFMNwEQ@mail.gmail.com
Whole thread Raw
In response to Re: Plan differences  (Pavel Stehule <pavel.stehule@gmail.com>)
List pgsql-performance
Hi,

It is looking like some missing optimization that was removed from RC release.

Thanks. Is there some discussion of why these optimisations were removed? I started looking at some of the more complicated queries I do and there are many occasions where there are 10-30x performance degradations compared with the RC. Not what I was hoping for with a much more powerful machine! Were these optimisations really dangerous? Is there any (easy and safe) way to get them back or would I need to reinstall an RC version?

Thanks again,
Anton

pgsql-performance by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: Plan differences
Next
From: Tom Lane
Date:
Subject: Re: Plan differences