cluster an index in Greenplum Database 760 Index Types 760 About Bitmap Indexes 761 When to Use Bitmap Indexes 761 When Not to Use Bitmap Indexes 761 Creating an Index 762 Indexes on Expressions 762 optimizer_enable_orderedagg server configuration parameter to true. The Query Optimizer (GPORCA) now supports bitmap scans on partitioned tables that contain both heap and AO partitions. Greenplum 6.20.0 now bundles that support fast searching for similar strings. The pageinspect module now includes support for bitmap indexes as described in the module documentation. If you are currently using the module in a database

cluster an index in Greenplum Database 600 Index Types 601 About Bitmap Indexes 601 When to Use Bitmap Indexes 601 When Not to Use Bitmap Indexes 602 Creating an Index 602 Indexes on Expressions 602 reported an error. 15389 Resolves an issue that caused queries using append-optmimized tables and bitmap indexes to run for a very long time with 100% CPU consumption. 16081 Resolves an issue where pg_ctl required that the predicate be in the form of . GPORCA now selects a more efficient bitmap index plan for both forms of the expression. 15617 Removes unneeded checks for memory allocation

cluster an index in Greenplum Database 571 Index Types 571 About Bitmap Indexes 572 When to Use Bitmap Indexes 572 When Not to Use Bitmap Indexes 573 Creating an Index 573 Indexes on Expressions 573 required that the predicate be in the form of . GPORCA now selects a more efficient bitmap index plan for both forms of the expression. 15617 Removes unneeded checks for memory allocation Resolves an issue where bitmap index creation on heap tables could fail due to out-of- order transaction IDs resulting from sync scans. Sync scans are now disallowed when building bitmap indexes. 32746 :

cluster an index in Greenplum Database 594 Index Types 595 About Bitmap Indexes 595 When to Use Bitmap Indexes 595 When Not to Use Bitmap Indexes 596 Creating an Index 596 Indexes on Expressions 596 Greenplum 6 Documentation VMware, Inc 144 32367, 14122 Resolved memory leaks related to dynamic bitmap scan on column-oriented tables. 32495 Resolved a performance issue that occured when Greenplum Database consumed a large amount of memory when GPORCA planned certain queries that generated a dynamic bitmap scan. 32307 Resolved a problem where GPORCA generated poor query plans because it did not permit

Database 573 Index Types 573 About Bitmap Indexes 573 When to Use Bitmap Indexes 574 VMware Tanzu Greenplum 6 Documentation VMware, Inc 24 When Not to Use Bitmap Indexes 574 Creating an Index 574 tables that had high numbers of partitions. 32367, 14122 Resolved memory leaks related to dynamic bitmap scan on column-oriented tables. 32495 Resolved a performance issue that occured when Greenplum Database consumed a large amount of memory when GPORCA planned certain queries that generated a dynamic bitmap scan. 32307 Resolved a problem where GPORCA generated poor query plans because it did not permit

cluster an index in Greenplum Database 570 Index Types 570 About Bitmap Indexes 570 When to Use Bitmap Indexes 571 When Not to Use Bitmap Indexes 571 Creating an Index 571 Indexes on Expressions 572 tables that had high numbers of partitions. 32367, 14122 Resolved memory leaks related to dynamic bitmap scan on column-oriented tables. 32495 Resolved a performance issue that occured when Greenplum Database consumed a large amount of memory when GPORCA planned certain queries that generated a dynamic bitmap scan. 32307 Resolved a problem where GPORCA generated poor query plans because it did not permit

Greenplum v6.19 Documentation VMware, Inc. 44 Index Types 771 About Bitmap Indexes 771 When to Use Bitmap Indexes 772 When Not to Use Bitmap Indexes 772 Creating an Index 772 Indexes on Expressions 773 Query Optimizer returned incorrect query results when the query plan included a materialize over a bitmap scan by removing the unnecessary projection of recheck/scalar filter columns. Cluster Management subquery when it pulls up sublinks. 11308 : Fixed a bug that caused data corruption during scan on bitmap index when there was an INSERT operation running in the backend. 10955 : Improved the logging and

cluster an index in Greenplum Database 487 Index Types 487 About Bitmap Indexes 487 When to Use Bitmap Indexes 488 When Not to Use Bitmap Indexes 488 Creating an Index 488 Indexes on Expressions 489 controlling fallback for replicated tables. 32238 ORCA now requires an index type to properly cost bitmap scans before performing full table scans. 32233 Eliminates query performance difference between testexpr are non-nullable. (Resolved by PR-13420.) 13446 Fixes incorrect scan position during bitmap index words scans. (Resolved by PR-13522.) 32205 Falls back to Planner from ORCA if a target list

Greenplum v6.18 Documentation VMware, Inc. 43 Index Types 762 About Bitmap Indexes 762 When to Use Bitmap Indexes 763 When Not to Use Bitmap Indexes 763 Creating an Index 763 Indexes on Expressions 764 not providing sufficient information to assist in diagnosing bitmap index issues. This has been resolved. pg_xlogdumpnow includes bitmap-related information. 179719406 : The pg_log utility was not providing providing sufficient information to assist in diagnosing bitmap index issues. This has been resolved. The bitmap index name is now included in Greenplum Database logs. Query Optimizer 31784 : If ANALYZE

Greenplum v6.17 Documentation VMware, Inc. 39 Index Types 694 About Bitmap Indexes 694 When to Use Bitmap Indexes 695 When Not to Use Bitmap Indexes 695 Creating an Index 695 Indexes on Expressions 696 Greenplum 6.16, introduced a regression that could cause incorrect results for queries having a bitmap index condition. This problem was resolved in 6.17.7 by reverting the original fix. Release 6.17 resolves a single issue. Resolved Issue Server 31807 Incorrect bitmap index page data was written to WAL logs, resulting in bitmap index corruption after failover to mirror segments or after crash