Support for 10 new Postgres extensions
We've added support for 10 new native PostgreSQL extensions.
New Extensions
autoinc - Functions for autoincrementing fields, providing automatic sequence-based field incrementing functionality.
bloom - Bloom filter index access method that provides space-efficient probabilistic data structure for fast membership testing.
dict_xsyn - Text search dictionary for extended synonym processing, enhancing full-text search capabilities with advanced synonym handling.
earthdistance - Calculate great circle distances on the surface of the Earth, perfect for geospatial applications requiring distance calculations.
insert_username - Functions for tracking who changed a table, automatically recording user information for audit trails.
intagg - Integer aggregator and enumerator functions (note: this extension is deprecated but available for legacy compatibility).
moddatetime - Functions for tracking last modification time, automatically updating timestamp fields when records are modified.
pgrowlocks - Show row-level locking information for debugging and monitoring database lock contention.
pgstattuple - Obtain tuple-level statistics to analyze table storage efficiency and bloat.
postgres_fdw - Foreign data wrapper for remote PostgreSQL servers, enabling federated queries across multiple PostgreSQL instances.
All extensions are now available for PlanetScale Postgres databases and can be enabled through the Extensions tab in your cluster configuration.