Search PostgreSQL documentation

Multixacts and WraparoundManual ChaptersPG1824.1.5.1. Multixacts and Wraparound Multixact IDs are used to support row locking by multiple transactions. Since there is only limited space in a tuple header to store lock information, tha…Multixacts and Wraparound MultiXactTruncationWait EventsReferenceMultiXactTruncation LWLock 10 Waiting to read or truncate multixact information. 11 12 13 14 15 16 17 18 19 20 9.6 A brief sample is normal around short internal critical sections. Investiga…Wait Events · LWLock mumakExtensionsExtensionsCardano CBOR parser blockchain cardano cbor pgrx mumak UtilitiesUtilities · Extensions musicbrainz_collateExtensionsExtensionsProvides Unicode Collation Algorithm support collation icu unicode postgresql_musicbrainz_collate UtilitiesUtilities · Extensions musicbrainz_unaccentExtensionsExtensionsRemoves accents from Unicode data accents canonicalization fts musicbrainz unaccent unicode postgresql_musicbrainz_unaccent Full-text searchFull-text search · Extensions mv_rewriteExtensionsExtensionsQuery rewriting extension that transparently rewrites queries to use lower-cost materialized views. materialized-view planner query-rewrite pg_fdw_mv_rewrite FeaturesFeatures · Extensions mv_statsExtensionsExtensionsTracks creation, alteration, refresh, and reset statistics for materialized views. event-trigger materialized-view statistics mv_stats MonitoringMonitoring · Extensions mvtblExtensionsExtensionsEasily move tables around tablespaces mvtbl AdministrationAdministration · Extensions mxid_ageFunctionsReferencemxid_age System Information Functions And Operators 13 Returns the number of multixacts IDs between the supplied multixact ID and the current multixacts counter. mxid_age ( xid ) → integer R…Functions · System Information Functions And Operators my_extensionExtensionsExtensionsA Basic PostgreSQL Extension calculation data extension gsoc postgresql postgresql-extension tutorial utility my_extension FeaturesFeatures · Extensions myextExtensionsExtensionsA useful and a flexible pattern for reloading postgres SQL extensions without losing data in extension-managed tables. pgsql postgres sql myext AdministrationAdministration · Extensions myhelperExtensionsExtensionsCollection of PostgreSQL helper functions admin array datetime diagnostics utility myhelper UtilitiesUtilities · Extensions mypg_shardingExtensionsExtensionsmypg sharding utilities for PostgreSQL distributed postgres-fdw sharding mypg_sharding AnalyticsAnalytics · Extensions mysql_fdwExtensionsExtensionsForeign data wrapper for querying a MySQL server mysql_fdw Foreign data wrappersForeign data wrappers · Extensions mysql_migratorExtensionsExtensionsTools for MySQL to PostgreSQL migration mysql_migrator Replication and streamsReplication and streams · Extensions mysqlcompatExtensionsExtensionsMySQL compatibility functions, aggregates, operators, and casts for PostgreSQL porting. compatibility conversion function mysql porting mysqlcompat CompatibilityCompatibility · Extensions nablaExtensionsExtensionsAsynchronous incremental materialized views with delta subscriptions ivm logical-decoding subscriptions nabla FeaturesFeatures · Extensions Named SQL Descriptor AreasManual ChaptersPG1834.7.1. Named SQL Descriptor Areas A named SQL descriptor area consists of a header, which contains information concerning the entire descriptor, and one or more item descriptor areas, which…Named SQL Descriptor Areas Namespace Available to GROUP BY and ORDER BYManual ChaptersPG18Namespace Available to GROUP BY and ORDER BY In the SQL-92 standard, an ORDER BY clause can only use output column names or numbers, while a GROUP BY clause can only use expressions based on…Namespace Available to GROUP BY and ORDER BY nanomsgtopdbExtensionsExtensionsReceive nanomsg messages into a PipelineDB stream. background-worker nanomsg pipelinedb nanomsgtopdb Replication and streamsReplication and streams · Extensions narugnExtensionsExtensionsA lightweight distributed computer narugn AnalyticsAnalytics · Extensions Native Language SupportManual ChaptersPG18Chapter 56. Native Language SupportNative Language Support natord_pgExtensionsExtensionsNatural-order comparison operators and btree operator class for PostgreSQL text values. operator ordering pgrx natord_pg Functions and aggregatesFunctions and aggregates · Extensions NEGATORManual ChaptersPG1836.15.2. NEGATOR The NEGATOR clause, if provided, names an operator that is the negator of the operator being defined. We say that operator A is the negator of operator B if both return Bool…NEGATOR neo4j-fdwExtensionsExtensionsMulticorn-based foreign data wrapper and Cypher functions for Neo4j. fdw multicorn neo4j plpython neo4j-fdw Foreign data wrappersForeign data wrappers · Extensions neo4j_fdwExtensionsExtensionsC foreign data wrapper for Neo4j Cypher query results. fdw neo4j neo4j_fdw Foreign data wrappersForeign data wrappers · Extensions neonExtensionsExtensionsNeon-specific statistics and Local File Cache metrics for Neon Postgres computes. cloud metrics preload storage neon MonitoringMonitoring · Extensions neon_utilsExtensionsExtensionsMonitor Neon Autoscaling compute allocation with num_cpus(). autoscaling neon neon_utils MonitoringMonitoring · Extensions netmaskFunctionsReferencenetmask Network Address Functions And Operators 10 construct netmask for network netmask ( inet ) → inet construct netmask for network 11 12 13 Computes the network mask for the address's ne…Functions · Network Address Functions And Operators networkFunctionsReferencenetwork Network Address Functions And Operators 10 extract network part of address network ( inet ) → cidr extract network part of address 11 12 13 Returns the network part of the address, z…Functions · Network Address Functions And Operators Network Address Functions and OperatorsManual ChaptersPG189.12. Network Address Functions and Operators The IP network address types, cidr and inet, support the usual comparison operators shown in Table 9.1 as well as the specialized operators and …Network Address Functions and Operators Network Address TypesManual ChaptersPG188.9. Network Address Types PostgreSQL offers data types to store IPv4, IPv6, and MAC addresses, as shown in Table 8.21. It is better to use these types instead of plain text types to store n…Network Address Types neurondbExtensionsExtensionsAI database extension for vector search, ML inference, hybrid search, and RAG in PostgreSQL. background-worker ml non-free rag vector neurondb AI and vectorsAI and vectors · Extensions newsfeedsExtensionsExtensionsPostgreSQL extension for gathering news pg_newsfeeds FeaturesFeatures · Extensions newtricksExtensionsExtensionsExamples of postgres extensions using rust pgrx rust newtricks FeaturesFeatures · Extensions nextgres_idcpExtensionsExtensionsNEXTGRES in-database connection pool extension for PostgreSQL. background-worker non-free pooler nextgres_idcp AdministrationAdministration · Extensions nextidExtensionsExtensionsGenerate Instagram-style sharded integer IDs. id-generator pg_nextid Functions and aggregatesFunctions and aggregates · Extensions nextvalFunctionsReferencenextval Sequence Manipulation Functions 10 Advance sequence and return new value nextval ( regclass ) → bigint Advance sequence and return new value 11 12 13 Advances the sequence object to …Functions · Sequence Manipulation Functions nfiestaExtensionsExtensionsPostgreSQL extension implementing nFIESTA forest inventory estimation functionality. estimation forestry postgis nfiesta Functions and aggregatesFunctions and aggregates · Extensions nfiesta_gisdataExtensionsExtensionsnfi gisdata database auxiliary variable greg estimator postgis nfiesta_gisdata GeospatialGeospatial · Extensions