2023 product updates

14.10.16.0

Minor engine version

Category	Description	References	Release date
New	Adds tiered storage to move infrequently accessed data to low-cost storage like Object Storage Service (OSS) and reduce storage costs.	Tiered storage	January 2024
New	Adds the `decoder_raw` output extension to reconstruct original SQL from logical replication changes.	decoder_raw	January 2024
Fixed issues	Improves performance for concurrent access on large tables.		January 2024
	Improves RTO throttling.		January 2024
	Fixes an issue in logical replication caused by statement-level transactions.		January 2024

Minor engine version

Category	Description	References	Release date
New	Introduces the PartitionedTableScan operator, which accelerates plan generation for partitioned tables, improving query performance and reducing memory usage for tables with many partitions.	PartitionedTableScan operator	December 2023
	Adds Global Plan Cache (GPC) to share execution plans across processes and improve memory efficiency.	Global Plan Cache (GPC)	December 2023
	Adds batch writes for `CREATE MATERIALIZED VIEW` and `REFRESH MATERIALIZED VIEW`, significantly speeding up these operations.	Batch writes for creating or refreshing materialized views	December 2023
	Adds drop flashback to quickly restore dropped tables, view and clear the recycle bin, and recover data.	Drop flashback	December 2023
	Lets you choose between ePQ and single-node execution based on table size or plan cost.	Control ePQ based on table size or cost	December 2023
Fixed issues	Fixes stability issues including a potential RSC spinlock deadlock and several incompatibilities in the `dbms_lob` package.		December 2023

Minor engine version

Category	Description	References	Release date
New	Adds the `pg_cron` extension to schedule jobs that run automatically at specified times or intervals using SQL.	pg_cron (scheduled jobs)	November 2023
Fixed issues	Fixes stability issues related to parallel execution and Ganos.		November 2023

Minor engine version

Category	Description	References	Release date
New	ePQ now supports parallel writes to and queries from OSS foreign tables, improving cold data archiving and querying.	ePQ supports parallel writes to and queries from OSS foreign tables	October 2023
New	The `oss_fdw` extension now supports ZSTD compression for improved compression ratio and speed.	oss_fdw (foreign tables for object storage)	October 2023
Fixed issues	Fixes stability issues related to Auto VACUUM, storage management, and global indexes.		October 2023

Minor engine version

Category	Description	References	Release date
New	Supports flexible predicate pull-up for correlated `IN`/`ANY` subqueries, expanding the optimizer search space for better execution plans.	Correlated subquery pull-up	August 2023
	Introduces real-time materialized views, which automatically reflect data changes from the base tables.	Real-time materialized views	August 2023
	Adds support for global caches, which share RelCache and CatCache data across processes.	Global metadata cache (Global Cache)	August 2023
Fixed issues	Fixes stability issues related to checkpoints and global indexes.		August 2023

Minor engine version

Category	Description	References	Release date
New	ePQ for can now be enabled with a single click.	Best practices	July 2023

Minor engine version

Category	Description	References	Release date
New	Adds the PASE extension for high-dimensional vector search in .	High-dimensional vector search (PASE)	June 2023

Ganos (v5.6)

Category	Description	References	Release date
New	Adds the `ST_AsMVT3D` and `ST_AsMVTGeom3D` functions to support 3D vector slice for Geometry3D data.	ST_AsMVT3D, ST_AsMVTGeom3D	June 2023
	Adds the `ST_AsTableFormat` function, which returns the type of the value returned by `ST_AsTable` for a trajectory.	ST_AsTableFormat	June 2023
	Adds support for importing glTF and glb files from OSS as SFMesh objects.	ST_ImportGLTF, ST_ImportGLB	June 2023
Fixed issues	Fixes an issue where `ST_intersection` incorrectly calculates the intersection of two overlapping line segments in a trajectory.	ST_intersection	June 2023

Minor engine version

Category	Description	References	Release date
New	Adds the `pg_roaringbitmap` extension to accelerate queries with bitmap calculations.	pg_roaringbitmap (compressed bitmaps)	May 2023

Ganos (v5.5)

Category	Description	References	Release date
New	Enhances the `ST_MosaicFrom` function to support parallel operations.	ST_MosaicFrom	May 2023
New	Enhances the `ST_MosaicFrom` function to support mosaicking rasters with different resolutions or projections.	ST_MosaicFrom	May 2023
Fixed issues	Fixes an issue where `ST_makeTrajectory` could cause a crash when creating a two-point trajectory from a start time and an end time.	ST_makeTrajectory	May 2023

Minor engine version

Category	Description	References	Release date
New	Adds support for replicating Data Definition Language (DDL) commands through logical replication.	DDL logical replication	April 2023
	Adds the `pldebugger` extension for debugging stored procedures.	pldebugger (debug stored procedures)	April 2023
	Adds the `polar_sql_mapping` extension to map incorrect SQL to corrected versions without modifying application code.	polar_sql_mapping	April 2023

Ganos (v5.4)

Category	Description	References	Release date
New	Adds the `ST_ClusterDBSCAN` function, which supports DBSCAN clustering on latitude and longitude coordinates.	ST_ClusterDBSCAN	April 2023
	Adds the `ST_CurveRecognize` function, which identifies curves and turning radii in a trajectory.	ST_CurveRecognize	April 2023
	Enhances the `ST_AsGrid` function to support 2D degenerate grid calculations.	ST_AsGrid	April 2023
	Upgrades the `pgRouting` extension to version 3.4.2.	pgRouting	April 2023

Minor engine version

Category	Description	References	Release date
New	Supports cross-node parallel acceleration and batch writes for creating materialized views.	Cross-node parallel acceleration for creating materialized views	March 2023
New	Improves security for database account permissions (ACL).	Account permissions	March 2023

Minor engine version

Category	Description	References	Release date
New	You can concurrently create indexes on partitioned tables with `CREATE INDEX CONCURRENTLY`.	Global index	February 2023
	The oss_fdw extension supports `TRUNCATE`.	None	February 2023
	Adds support for recovery bulk extend.	None	February 2023

Ganos (v5.3)

Category	Description	References	Release date
New	Adds the `ST_Angle` function, which returns an array of the rotation angles at each corner of a trajectory.	ST_Angle	February 2023
	Adds the `ST_CurvatureRadius` function, which returns an array of the curvature radii at each corner of a trajectory.	ST_CurvatureRadius	February 2023
	Upgrades PostGIS extension compatibility to version 3.3.2.	PostGIS	February 2023
Fixed issues	Fixed an issue where the `ST_AsTable` trajectory function crashed when the `x,y,t` dimensions were NULL.		February 2023

Minor engine version

Category	Description	References	Release date
New	Adds global indexes for partitioned tables, supporting indexes on non-partition keys and unique constraints.	Global index	January 2023
New	You can specify the `Storage` parameter when you create a table.	None	January 2023