BUG #14015: Query Plan not optimal

Started by Jamie Koceniakabout 10 years ago1 messagesbugs

jkoceniak@mediamath.com

about 10 years ago

The following bug has been logged on the website:

Bug reference: 14015
Logged by: Jamie Koceniak
Email address: jkoceniak@mediamath.com
PostgreSQL version: 9.4.6
Operating system: Linux - Debian
Description:

One of our queries seems to have reverted back to an old query plan after
updating from 9.4.5 to 9.4.6.

9.4.6 execution time: 1045.368 ms
9.4.5 Execution time: 0.276 ms

We experienced the same issue with version 9.1 where the index scan is
looping too much

Bad plan:
Index Scan using idx1 on orders (cost=0.29..6.38 rows=11 width=25)
(actual time=0.002..0.003 rows=1 loops=103015)

--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs