diff options
author | Tom Lane <tgl@sss.pgh.pa.us> | 2012-02-08 12:41:48 -0500 |
---|---|---|
committer | Tom Lane <tgl@sss.pgh.pa.us> | 2012-02-08 12:41:48 -0500 |
commit | cbba55d6d792b55f6b448a31fc14aef84510967c (patch) | |
tree | 79718d5a433fe74e552518a4269f66d6718576d8 /src/backend/access/gist | |
parent | 3db6524fe63f0598dcb2b307bb422bc126f2b15d (diff) | |
download | postgresql-cbba55d6d792b55f6b448a31fc14aef84510967c.tar.gz postgresql-cbba55d6d792b55f6b448a31fc14aef84510967c.zip |
Support min/max index optimizations on boolean columns.
Since bool_and() is equivalent to min(), and bool_or() to max(), we might
as well let them be index-optimized in the same way. The practical value
of this is debatable at best, but it seems nearly cost-free to enable it.
Code-wise, we need only adjust the entries in pg_aggregate. There is a
measurable planning speed penalty for a query involving one of these
aggregates, but it is only a few percent in simple cases, so that seems
acceptable.
Marti Raudsepp, reviewed by Abhijit Menon-Sen
Diffstat (limited to 'src/backend/access/gist')
0 files changed, 0 insertions, 0 deletions