projects / users / c2main / postgres.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 5338847) | 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:33 +0000 (06:50 +0000)
committerTom Lane <tgl@sss.pgh.pa.us>
Tue, 6 Feb 2007 06:50:33 +0000 (06:50 +0000)
commita95abdf8564e36b7c9de62423fcbe039fcc20efa
tree09750e90a9a1b1e8dd5d786e04ec81413de872e4tree
parent5338847fcd105554e4eee92c3f5477f41bdc2e68commit | 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 | blame | history
Cedric's Stuff