Uploaded November 2026 | Updated November 2026, 6 hours ago
Explore the new storage and performance optimizations in the Tanzu Greenplum 7.6 release. We demonstrate how native columnar improvements and hardware acceleration boost query efficiency and cut I/O overhead.
Key Highlights:
Implied Indexes: Speed up columnar sequential and index scans without creating external indexes by natively leveraging storage layouts.
Block Directory Requirements: Learn the SQL syntax needed to set up and maintain block directories to enable implied indexes.
Visibility Check Optimizations: Accelerate append-optimized columnar (AOC) table queries with streamlined visibility checks for updates, deletes, and added columns.
Hardware Acceleration: Leverage runtime SIMD/AVX instruction checks to speed up vectorized CRC calculations and bitmap operations by up to 50%.
00:00 Storage and replication in Greenplum 7.6
01:52 Implied indexes for columnar tables
03:41 How a columnar scan works today
06:16 Where external indexes fall short
08:32 How implied indexes work
11:47 Turning on the block directory
12:55 Where the savings come from
15:50 Benchmarks: selectivity and columns selected
20:20 Many columns in the WHERE clause, AND vs OR
23:59 Implied indexes vs B-tree indexes
25:49 Faster visibility checks on columnar tables
28:41 Tables that went through ADD COLUMN
29:59 Visibility check benchmarks
33:15 Vectorized CRC with SIMD instructions
36:07 AVX for bitmap operations
37:30 Wrap-up
Presented by Ashwin Agrawal, tech lead for Tanzu Greenplum, with Venkatesh (Venky), product lead for Tanzu Greenplum.
#TanzuGreenplum #Greenplum #DataWarehouse #PostgreSQL
Explore the new storage and performance optimizations in the Tanzu Greenplum 7.6 release. We demonstrate how native columnar improvements and hardware acceleration boost query efficiency and cut I/O overhead.
Key Highlights:
Implied Indexes: Speed up columnar sequential and index scans without creating external indexes by natively leveraging storage layouts.
Block Directory Requirements: Learn the SQL syntax needed to set up and maintain block directories to enable implied indexes.
Visibility Check Optimizations: Accelerate append-optimized columnar (AOC) table queries with streamlined visibility checks for updates, deletes, and added columns.
Hardware Acceleration: Leverage runtime SIMD/AVX instruction checks to speed up vectorized CRC calculations and bitmap operations by up to 50%.
00:00 Storage and replication in Greenplum 7.6
01:52 Implied indexes for columnar tables
03:41 How a columnar scan works today
06:16 Where external indexes fall short
08:32 How implied indexes work
11:47 Turning on the block directory
12:55 Where the savings come from
15:50 Benchmarks: selectivity and columns selected
20:20 Many columns in the WHERE clause, AND vs OR
23:59 Implied indexes vs B-tree indexes
25:49 Faster visibility checks on columnar tables
28:41 Tables that went through ADD COLUMN
29:59 Visibility check benchmarks
33:15 Vectorized CRC with SIMD instructions
36:07 AVX for bitmap operations
37:30 Wrap-up
Presented by Ashwin Agrawal, tech lead for Tanzu Greenplum, with Venkatesh (Venky), product lead for Tanzu Greenplum.
#TanzuGreenplum #Greenplum #DataWarehouse #PostgreSQL










