]> granicus.if.org Git - postgresql/commit
projects / postgresql / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 91e18db) | patch
Fix a performance regression in 8.2: optimization of MIN/MAX into indexscans
authorTom Lane <tgl@sss.pgh.pa.us>
Tue, 6 Feb 2007 06:50:26 +0000 (06:50 +0000)
committerTom Lane <tgl@sss.pgh.pa.us>
Tue, 6 Feb 2007 06:50:26 +0000 (06:50 +0000)
commit56e59edd7509f8726157cd8039529fc077f57ebb
treeb7dc7fa4d6a3549b884e5f2ec1d110b299fba6e0tree | snapshot
parent91e18dbbccd6ec00e6b1f879d98bbd9376a0689bcommit | diff
Fix a performance regression in 8.2: optimization of MIN/MAX into indexscans
had stopped working for tables buried inside views or sub-selects.  This is
because I had gotten rid of the simplify_jointree() preprocessing step, and
optimize_minmax_aggregates() wasn't smart enough to deal with a non-canonical
FromExpr.  Per gripe from Bill Howe.
src/backend/optimizer/plan/planagg.c diff | blob | history
Unnamed repository; edit this file 'description' to name the repository.