]> git.ipfire.org Git - thirdparty/postgresql.git/commit
projects / thirdparty / postgresql.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 1a09100) | patch
Use ORDER BY on matview definitions were needed for stable plans.
authorKevin Grittner <kgrittn@postgresql.org>
Tue, 19 Mar 2013 15:33:37 +0000 (10:33 -0500)
committerKevin Grittner <kgrittn@postgresql.org>
Tue, 19 Mar 2013 15:33:37 +0000 (10:33 -0500)
commit241139ae4baf6264c3c2cd053a547833c6e49a59
treeccdb5405ef3cda467fa0537e4cbce7f556c9a8eetree
parent1a091002cfa2180a908b36d56c58749a175b4be7commit | diff
Use ORDER BY on matview definitions were needed for stable plans.

Per report from Hadi Moshayedi of matview regression test failure
with optimization of aggregates.  A few ORDER BY clauses improve
code coverage for matviews while solving that problem.
src/test/regress/expected/matview.out diff | blob | blame | history
src/test/regress/sql/matview.sql diff | blob | blame | history
Mirror of https://git.postgresql.org/git/postgresql.git