PolarDB for PostgreSQL 14

Category

Description

References

Release date

New features

Supports reading WAL logs from the WAL buffer for physical and logical replication.

Read WAL logs from the WAL buffer for physical and logical replication

December 2024

Supports transforming OR clauses into UNION ALL for query optimization.

OR to UNION ALL transformation

December 2024

Performance optimizations

Enables the adaptive function whitelist by default to improve load balancing for cluster endpoints.

None

December 2024

Improves performance in some common scenarios.

None

December 2024

Bug fixes

Fixes an issue where global index kill processes incorrect index tuples, causing global index errors in rare cases.

December 2024

Fixes a null pointer bug in pg_hint_plan that occurs when processing virtual indexes.

December 2024

Category

Description

References

Release date

New feature

Adds the TSDB extension, enabling advanced features for time-series computing.

Time Series Database

November 2024

Performance optimization

Optimizes performance in some common scenarios.

N/A

November 2024

Bug fixes

Fixes incompatibilities with certain character sets.

November 2024

Fixes a memory leak in the bitmap operator.

November 2024

Fixes some stability issues.

November 2024

Category

Description

References

Release date

New features

Supports Segmented Least Recently Used (SLRU) shard management.

None

September 2024

Index creation and VACUUM FULL operations now support the fallocate no_hide_stale option for enhanced data integrity.

None

September 2024

Adds monitoring for the full-page snapshot feature.

None

September 2024

Adds control over the default pushdown behavior for Common Table Expressions (CTEs).

None

September 2024

Adds the temporal_tables extension to support system-period temporal tables.

temporal_tables (temporal tables)

September 2024

Supports setting the session isolation level with the ALTER SESSION SET ISOLATION_LEVEL statement.

None

September 2024

Upgrades the spatio-temporal database (Ganos) to version 6.9.

Spatio-temporal database release notes

September 2024

Performance optimization

Adjusts the default private cache size for GCC and GRC processes. This optimizes performance for transactions that involve many Data Definition Language (DDL) operations.

Global Cache

September 2024

Bug fixes

Fixes an issue where, after streaming replication transferred xlog meta, the startup process failed to wake up promptly.

September 2024

Fixes an issue where a stored procedure Cache failure caused a Cache lookup failed error.

September 2024

Fixes an issue that prevented archiving indexes to OSS if they were not in the Public schema.

September 2024

Fixes an issue where the cold data cache did not roll back correctly when a query was canceled.

September 2024

Fixes an incorrect calculation of the compression ratio in shared storage mode.

September 2024

Fixes an issue where pg_cron failed because the unix_socket_directories parameter was set to a quoted value.

September 2024

Fixes an issue where the Logindex saver process failed to start when Logindex was disabled.

September 2024

Fixes a memory allocation issue in GPC.

September 2024

Category

Description

References

Release date

New features

supports multitenancy resource control.

Multitenancy

August 2024

Upgraded the spatio-temporal database (Ganos) to version 6.8.

Release notes for the spatio-temporal database

August 2024

Error messages for data type mismatches now display specific column names.

N/A

August 2024

The primary node can now ignore the replay latency of read-only nodes when flushing dirty pages.

N/A

August 2024

Performance optimizations

Index creation is now approximately three times faster.

N/A

August 2024

Optimized temporary tables of the ON COMMIT DELETE ROWS type.

N/A

August 2024

Increased the batch pre-read limit for WAL in logical replication.

Parallel WAL replay

August 2024

Improved the execution efficiency of STABLE functions.

N/A

August 2024

Optimized the adaptive function whitelist.

N/A

August 2024

Bug fixes

Fixed a vulnerability related to reading from and writing to local files in the spatio-temporal database (Ganos).

August 2024

Fixed an issue where a residual errno value could be left in the LOCAL CACHE.

August 2024

Fixed an error with serial type fields in ALTER FOREIGN TABLE statements when DDL logical replication is enabled.

August 2024

Fixed an issue where pg_dump failed to export polar_advisor objects.

August 2024

Fixed severe lock contention caused by the dirty page flushing process identifying future pages.

August 2024

Fixed an assert issue in async lock.

August 2024

Category

Description

References

Release date

New feature

now supports archiving table partitions to OSS by timeline.

Automatically archive partitioned tables to cold storage by timeline

August 2024

Performance optimization

improves the replay speed of the relation size cache (RSC) on replica nodes.

Relation size cache (RSC)

August 2024

Bug fix

Fixes an issue where the pldebugger extension did not allow a polar_superuser to debug other users' functions.

August 2024

Category

Description

References

Release date

Bug fix

Fixes an error when executing an INSERT INTO SELECT statement on a table with a columnstore index.

July 2024

Category

Description

References

Release date

New feature

supports tiered storage of hot and cold data.

tiered storage of hot and cold data

June 2024

Category

Description

References

Release date

New features

Upgrades the pgvector extension to improve recall rate and performance.

pgvector (vector search)

May 2024

Bug fixes

Improves the stability of the Ganos trajectory module.

May 2024

Fixes a reference count overflow in the shared memory of the Global Plan Cache (GPC) that causes new connections to fail.

May 2024

Category

Description

References

Release date

New feature

now supports basic automatic index recommendation.

Automatic index recommendation

April 2024

Bug fixes

Fixes a bug in polar_dump when handling variable-length data types.

April 2024

Fixes a bug in the postgres_fdw extension when it references dblink.

April 2024

Category

Description

References

Release date

New features

adds the imgsmlr extension. This extension extracts feature values from images, such as PNG and GIF files, and retrieves similar images using an index.

imgsmlr (similar images)

March 2024

adds the pg_profile extension. This extension collects statistics on resource-intensive activities in the target database for periodic monitoring.

pg_profile (resource monitoring)

March 2024

adds the pg_similarity extension for similarity queries.

pg_similarity (similarity distance calculation)

March 2024

adds the prefix extension for string prefix matching.

prefix (prefix matching)

March 2024

Bug fix

Fixes issues such as errors when using PL/SQL and PL/pgSQL together, and failures to create the ganos_utility extension.

March 2024

Category

Description

References

Release date

New feature

now supports using any column as a primary key or foreign key in a partitioned table.

Use any column in a partitioned table as the primary key

February 2024

Bug fixes

Fixes bugs and performance issues with global indexes on partitioned tables.

February 2024

Fixes an error when calling a constructor function for a type body with a specified schema.

February 2024