Release notes 5.5.0 as of 2021-04-26

New functionality

The following features are new in this release:

[SDB-9209]

The settings advisor now covers settings that depend on your specific hardware.

[SDB-9737]

For a more successful installation, now you are reminded of follow-up steps after creating or updating the extension, or loading the license.

[SDB-9599]

You can now analyze query performance and workloads via additional information in the EXPLAIN output and the performance analyzer (still experimental).

[SDB-10006]

You can now manually update all columnstore index caches with the swarm64da.columnstore_update_full() function.

[SDB-10015]

Support for all CPUs with the x86-64 architecture.

Improvements

The following features are improved in this release:

[SDB-9954]

Adjusted the IO priority in columnstore scans and accelerated sequential scans, so your transactional queries have a more consistent performance.

[SDB-9979][SDB-9986]

Improved startup time and performance of the shuffle node for fast queries.

[SDB-9987]

Improved the performance of the join node on columns with variable length data types.

[SDB-9988]

The planner no longer emits columnstore scans on tables with low row estimates.

Fixes

The following issues are fixed in this release:

[SDB-9901][SDB-9958]

Long running queries do no longer block progress of the columnstore updater.

[SDB-9923]

Columnstore indexes no longer occasionally become unusable, when the database crashed during checkpointing or recovery because of external reasons.

[SDB-9935]

The planner no longer emits the output buffer for queries that contain incompatible nodes, such as INTERSECT.

[SDB-9955]

The planner no longer overstimate the row counts of columnstore scans for small row counts.

[SDB-9964]

Columnstore scans do no longer fail in a standby node.

[SDB-9966]

Columnstore indexes no longer oaccsionally become unusable when the original heap table is truncated.

[SDB-9956]

Optimized anti and semi joins are used in more places.

Known issues

There are no known issues in this release.