Обсуждение: BUG #10547: Query too long with order and limit

The following bug has been logged on the website:

Bug reference:      10547
Logged by:          Arnaud Lamy
Email address:      alamy@ltutech.com
PostgreSQL version: 9.2.4
Operating system:   Linux
Description:

Hi guys,

After double checked with #postgresqlfr users, I think I have a bug.

With the pastebin below, if I add a limit to my query the behavior totally
change. It could take minutes instead of milliseconds.

explain and query:

http://paste.debian.net/103554/

Please let me know if you need more informations.

I tested with 9.4, same behavior.

Arnaud

On Fri, Jun 6, 2014 at 6:55 PM,  <alamy@ltutech.com> wrote:
> explain and query:
>
> http://paste.debian.net/103554/
The query and the output should be directly posted here. If in the
future a user looks at the archives for a problem similar to yours and
click on the link you are providing here, they may find nothing that
could help.

> Please let me know if you need more informations.
The query and the plan. The url you provided does not work.
--
Michael