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
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
On Fri, Jun 6, 2014 at 6:55 PM, <alamy@ltutech.com> wrote:
explain and query:
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
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs