Search PostgreSQL documentation

base36_gistExtensionsExtensionsPostgreSQL base36 data type input/output support, internally a bigint. base36_gist FeaturesFeatures · Extensions base62ExtensionsExtensionsBase62 extension for PostgreSQL pg_base62 Functions and aggregatesFunctions and aggregates · Extensions basebackup_to_shellExtensionsPG18F.4. basebackup_to_shell — example "shell" pg_basebackup module basebackup_to_shell adds a custom basebackup target called shell. This makes it possible to run pg_basebackup --target=shell o…basebackup_to_shell — example "shell" pg_basebackup module basebackup_to_shell — example "shell" pg_basebackup moduleManual ChaptersPG18F.4. basebackup_to_shell — example "shell" pg_basebackup module basebackup_to_shell adds a custom basebackup target called shell. This makes it possible to run pg_basebackup --target=shell o…basebackup_to_shell — example "shell" pg_basebackup module BasebackupReadWait EventsReferenceBasebackupRead IO 14 Waiting for base backup to read from a file. 15 16 17 18 19 20 The wait is normal when the workload is expected to perform this read, write, sync, allocation, or complet…Wait Events · IO BasebackupSyncWait EventsReferenceBasebackupSync IO 15 Waiting for data written by a base backup to reach durable storage. 16 17 18 19 20 The wait is normal when the workload is expected to perform this read, write, sync, al…Wait Events · IO BaseBackupThrottleWait EventsReferenceBaseBackupThrottle Timeout 10 Waiting during base backup when throttling activity. 11 12 13 14 15 16 17 18 19 20 The wait is normal when the configured policy is intentional and useful work …Wait Events · Timeout BasebackupWriteWait EventsReferenceBasebackupWrite IO 15 Waiting for base backup to write to a file. 16 17 18 19 20 The wait is normal when the workload is expected to perform this read, write, sync, allocation, or completion…Wait Events · IO basejump-supabase_test_helpersExtensionsExtensionsA collection of functions designed to make testing Supabase projects easier. pgtap supabase testing supabase_test_helpers FeaturesFeatures · Extensions basejump_coreExtensionsExtensionsBasejump adds accounts, teams, permissions and billing to Supabase. auth billing dbdev supabase tle basejump-basejump_core FeaturesFeatures · Extensions Basic API Structure for IndexesManual ChaptersPG1863.1. Basic API Structure for Indexes Each index access method is described by a row in the pg_am system catalog. The pg_am entry specifies a name and a handler function for the index access…Basic API Structure for Indexes Basic ConfigurationManual ChaptersPG1826.2.8.1. Basic Configuration Once streaming replication has been configured, configuring synchronous replication requires only one additional configuration step: synchronous_standby_names m…Basic Configuration Basic Regular ExpressionsManual ChaptersPG189.7.3.7. Basic Regular Expressions BREs differ from EREs in several respects. In BREs, |, +, and ? are ordinary characters and there is no equivalent for their functionality. The delimiters …Basic Regular Expressions Basic SetupManual ChaptersPG1818.10.1. Basic Setup The PostgreSQL server will listen for both normal and GSSAPI-encrypted connections on the same TCP port, and will negotiate with any connecting client whether to use GSS…Basic Setup Basic SetupManual ChaptersPG1818.9.1. Basic Setup With SSL support compiled in, the PostgreSQL server can be started with support for encrypted connections using TLS protocols enabled by setting the parameter ssl to on i…Basic Setup Basic StatementsManual ChaptersPG1841.5. Basic Statements In this section and the following ones, we describe all the statement types that are explicitly understood by PL/pgSQL. Anything not recognized as one of these stateme…Basic Statements Basic Text MatchingManual ChaptersPG1812.1.2. Basic Text Matching Full text searching in PostgreSQL is based on the match operator @@, which returns true if a tsvector (document) matches a tsquery (query). It doesn't matter whic…Basic Text Matching basic_archiveExtensionsPG18F.5. basic_archive — an example WAL archive module basic_archive is an example of an archive module. This module copies completed WAL segment files to the specified directory. This may not b…basic_archive — an example WAL archive module basic_archive — an example WAL archive moduleManual ChaptersPG18F.5. basic_archive — an example WAL archive module basic_archive is an example of an archive module. This module copies completed WAL segment files to the specified directory. This may not b…basic_archive — an example WAL archive module bdrExtensionsExtensionsActive-active logical replication and distributed consistency for PGD. replication active-active distributed conflict bdr Replication and streamsReplication and streams · Extensions bedquiltExtensionsExtensionsA json object store bedquilt bedquiltdb document store json json store jsonb object store bedquilt FeaturesFeatures · Extensions BEGINManual ChaptersPG18BEGIN BEGIN — start a transaction block Synopsis BEGIN [ WORK | TRANSACTION ] [ transaction_mode [, ...] ] where transaction_mode is one of: ISOLATION LEVEL { SERIALIZABLE | REPEATABLE READ …BEGIN BEGINSQL CommandsReferenceBEGIN Transactions 10 start a transaction block BEGIN [ WORK | TRANSACTION ] [ transaction_mode [, ...] ] where transaction_mode is one of: ISOLATION LEVEL { SERIALIZABLE | REPEATABLE READ…SQL Commands · Transactions BehaviorManual ChaptersPG1823.1.2. Behavior The locale settings influence the following SQL features: Sort order in queries using ORDER BY or the standard comparison operators on textual data The upper, lower, and ini…Behavior Behavior in Threaded ProgramsManual ChaptersPG1832.21. Behavior in Threaded Programs As of version 17, libpq is always reentrant and thread-safe. However, one restriction is that no two threads attempt to manipulate the same PGconn object…Behavior in Threaded Programs Behavior of B-Tree Operator ClassesManual ChaptersPG1865.1.2. Behavior of B-Tree Operator Classes As shown in Table 36.3, a btree operator class must provide five comparison operators, <, <=, =, >= and >. One might expect that <> should also be…Behavior of B-Tree Operator Classes believeExtensionsExtensionsThe official PostgreSQL extension for the Believe API. believe UtilitiesUtilities · Extensions bench_pg_unwindExtensionsExtensionsBenchmark PostgreSQL/Rust exception unwinding overhead benchmark developer-tools rust bench_pg_unwind FeaturesFeatures · Extensions BenchmarkManual ChaptersPG18F.19.4. Benchmark The source directory contrib/intarray/bench contains a benchmark test suite, which can be run against an installed PostgreSQL server. (It also requires DBD::Pg to be instal…Benchmark Benchmarking OptionsManual ChaptersPG18Benchmarking Options pgbench accepts the following command-line benchmarking arguments: -b scriptname[@weight]--builtin=scriptname[@weight] Add the specified built-in script to the list of s…Benchmarking Options Best Practices for Declarative PartitioningManual ChaptersPG185.12.6. Best Practices for Declarative Partitioning The choice of how to partition a table should be made carefully, as the performance of query planning and execution can be negatively affe…Best Practices for Declarative Partitioning beyond_authExtensionsExtensionsPer-project authentication and authorization service for apps running on https://beyond.dev auth authn authorization authz beyond beyond-dev copy-on-write cow postgres-extension zanzibar bey…Security · Extensions beyond_queueExtensionsExtensionsA faster fork of pgmq for https://beyond.dev queues beyond beyond-dev copy-on-write cow pgmq postgres postgres-extension postgres-queue queue beyond_queue FeaturesFeatures · Extensions bfnExtensionsExtensionsRust/pgrx utility extension with UUID, date, string, JSON/address, and validation helper functions. pgrx utility bfn UtilitiesUtilities · Extensions bg_monExtensionsExtensionsBackground worker for monitoring PostgreSQL background-worker monitoring statistics bg_mon MonitoringMonitoring · Extensions bgvalidatorsExtensionsExtensionsValidation functions for IBAN, Bulgarian EGN personal IDs, BULSTAT VAT numbers, and LNCh foreigner IDs. check digit egn iban lnch bgValidators Functions and aggregatesFunctions and aggregates · Extensions bgw_replstatusExtensionsExtensionsSmall PostgreSQL background worker to report whether a node is a replication master or standby bgw_replstatus MonitoringMonitoring · Extensions bgworker_segfaultExtensionsExtensionsMinimal Rust/pgrx background-worker crash reproducer for max_worker_processes exhaustion. background-worker crash-reproducer pgrx bgworker_segfault FeaturesFeatures · Extensions BgworkerShutdownWait EventsReferenceBgworkerShutdown IPC 10 Waiting for background worker to shut down. 11 12 13 14 15 16 17 18 19 20 Brief rendezvous is normal when every participant continues to advance. Investigate when the…Wait Events · IPC BgworkerStartupWait EventsReferenceBgworkerStartup IPC 10 Waiting for background worker to start up. 11 12 13 14 15 16 17 18 19 20 Brief rendezvous is normal when every participant continues to advance. Investigate when the s…Wait Events · IPC