Planner Row-Count Errors

Multi-column filter conditions lead to poor selectivity estimate

http://archives.postgresql.org/message-id/[email protected]

http://archives.postgresql.org/message-id/[email protected]

http://archives.postgresql.org/message-id/CAJg-yaMyR03J43RLMToB27YdtK7w-vguot2fYKz+0sFHVRsjwA@mail.gmail.com

http://archives.postgresql.org/message-id/CA+TgmoY1Qhi6-8iz_y6Qr_Wnjcs_BXufHHOZPuBqij_4jewVHQ@mail.gmail.com

http://archives.postgresql.org/message-id/[email protected]

http://archives.postgresql.org/message-id/[email protected]

http://archives.postgresql.org/message-id/CAAB3BBL4JyD7cPo6uxnYL0-2CdtW+UdWP16pyOm85yEEtJqh2Q@mail.gmail.com

http://archives.postgresql.org/message-id/[email protected]

http://archives.postgresql.org/message-id/CAAX5s64o2LCF0cWNqDMTiM1JuSyyESvh1T1QW1cmDTpi4n2rdg@mail.gmail.com

http://archives.postgresql.org/message-id/CAETCRjg_3kp-MniE6ZmEH4ZMSE4xiSD=01vsuXrQae4Yxwq32Q@mail.gmail.com [debatable]

http://www.postgresql.org/message-id/CAFmVg3jE_HymBX558M5+Hh3iaUm7OAj_FVk98SGuGk8B3sWuvA@mail.gmail.com

http://www.postgresql.org/message-id/[email protected]

Correlations between columns values aren't recognized

http://archives.postgresql.org/message-id/CAMOxC8vN4RzrzDEgWxXxdyfjCZfAzC8TbznakzmQE3q8=XL6sw@mail.gmail.com

ORDER BY + LIMIT

http://archives.postgresql.org/message-id/[email protected]

http://archives.postgresql.org/message-id/[email protected]

http://archives.postgresql.org/message-id/[email protected]

http://archives.postgresql.org/message-id/[email protected]

http://archives.postgresql.org/message-id/CAC7CH7GB2Yi1VqQ9hy8Yex0avGvgLfvQkHabFGfmZa1WRU3X+A@mail.gmail.com

http://archives.postgresql.org/message-id/[email protected]

http://archives.postgresql.org/message-id/[email protected]

http://www.postgresql.org/message-id/[email protected]

http://www.postgresql.org/message-id/[email protected]

http://archives.postgresql.org/message-id/[email protected]

http://archives.postgresql.org/message-id/[email protected]

Can't See Through WITH

http://archives.postgresql.org/message-id/[email protected]

http://archives.postgresql.org/message-id/[email protected]

http://archives.postgresql.org/message-id/CALi4Upj-XjcFHzP0ebY4GOZtegjk4m+uwESRL97ZhgugR9Dhcw@mail.gmail.com

http://archives.postgresql.org/message-id/[email protected]

http://archives.postgresql.org/message-id/[email protected]

Generic plans can suck

http://archives.postgresql.org/message-id/864BF5C35722CC4C880BE29B65FD396B4DBB059BEF@exchg1-bv.drm-bv.deuromedia.com

http://archives.postgresql.org/message-id/[email protected]

http://archives.postgresql.org/message-id/[email protected]

http://archives.postgresql.org/message-id/[email protected]

Selectivity estimates on arbitrary expressions are poor

http://archives.postgresql.org/message-id/CA+TgmoY1Qhi6-8iz_y6Qr_Wnjcs_BXufHHOZPuBqij_4jewVHQ@mail.gmail.com

http://archives.postgresql.org/message-id/[email protected]

http://www.postgresql.org/message-id/CAH3i69kRk=cQqpB3Q8oLGxmJhNbpSPhtFGX7DKbPptnDgh5z2w@mail.gmail.com

http://www.postgresql.org/message-id/[email protected]

Join selectivity doesn't know about cross-table correlations

http://www.postgresql.org/message-id/CAGoODpdTE__dLDhJe2d_4dwZj0YOx1vp7O-Lrwj2pYtxdMeBKw@mail.gmail.com

http://www.postgresql.org/message-id/CACfv+pLwqw-c=kR65WjA_pFy9M2qoKM2Usy77BoD8QWNwcfGHA@mail.gmail.com

http://www.postgresql.org/message-id/[email protected]

Uncommitted tuples don't affect statistics

http://archives.postgresql.org/message-id/[email protected]

http://www.postgresql.org/message-id/[email protected]

Histogram bounds can slide due to new data [Fixed]

http://archives.postgresql.org/message-id/[email protected]

Inheritance parents aren't assumed to be completely empty [Fixed]

http://archives.postgresql.org/message-id/[email protected]

no stats for WITH RECURSIVE

http://archives.postgresql.org/message-id/CAGTBQpYLZ2zHXhet+7W-gpeurf9gTUsM6Z+g1rxeRjySByJBMw@mail.gmail.com

GROUP BY output has no statistics

http://archives.postgresql.org/message-id/[email protected]

redundant equality constraints not identified as such

http://archives.postgresql.org/message-id/CAA2LLOEy2n6swjgBRGp2DZvVtMg4AGYSyA2FKFd6FKxscv5rSQ@mail.gmail.com

IN/NOT IN estimation doesn't assume array elements are distinct [fixed in 9.2]

http://archives.postgresql.org/message-id/CA+mi_8ZcOCdKuYY+_DazyzxR87Afv-nDPgSdm=C8rurEFJix8w@mail.gmail.com