| From: | jkoceniak(at)mediamath(dot)com |
|---|---|
| To: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | BUG #14015: Query Plan not optimal |
| Date: | 2016-03-10 20:50:29 |
| Message-ID: | 20160310205029.8904.56087@wrigleys.postgresql.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
The following bug has been logged on the website:
Bug reference: 14015
Logged by: Jamie Koceniak
Email address: jkoceniak(at)mediamath(dot)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)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dmitriy Sarafannikov | 2016-03-11 08:16:51 | Re[2]: [BUGS] Too many files in pg_replslot folder |
| Previous Message | Rich Schaaf | 2016-03-10 19:44:39 | Bad interaction between pg_dump/pg_restore and table inheritance |