Search PostgreSQL documentation

Partitioning and Constraint ExclusionManual ChaptersPG18Table PartitioningConstraint exclusion is a query optimization technique similar to partition pruning. While it is primarily used for partitioning implemented using the legacy inheritance method, it can be us… Partitioning Using InheritanceManual ChaptersPG18Table PartitioningWhile the built-in declarative partitioning is suitable for most common use cases, there are some circumstances where a more flexible approach may be useful. Partitioning can be implemented … partman_to_cstoreExtensionsExtensionsAnalytics · ExtensionsMove old pg_partman partitions to cstore columnar storage. archive columnar cstore partitioning pg-partman partman_to_cstore Analytics paseExtensionsExtensionsAI and vectors · ExtensionsPostgreSQL ultra-high dimensional approximate nearest neighbor search extension. ann similarity vector pase AI and vectors passfileCommand-line ToolsPG18Database Connection Control Functions › Parameter Key WordsSpecifies the name of the file used to store passwords (see Section 32.16). Defaults to ~/.pgpass, or %APPDATA%\postgresql\pgpass.conf on Microsoft Windows. (No error is reported if this fil… Passing Query Parameters Using an SQLDAManual ChaptersPG18Using Descriptor AreasThe general steps to use an SQLDA to pass input parameters to a prepared query are: Create a prepared query (prepared statement) Declare an sqlda_t structure as an input SQLDA. Allocate memo… passwd-fdwExtensionsExtensionsForeign data wrappers · ExtensionsForeign data wrapper for Unix/Linux passwd and group databases. passwd_fdw Foreign data wrappers passwordCommand-line ToolsPG18Database Connection Control Functions › Parameter Key Wordsto be used if the server demands password authentication. passwordExtensionsExtensionsData types · ExtensionsPostgreSQL data type for passwords password Data types Password AuthenticationManual ChaptersPG18There are several password-based authentication methods. These methods operate similarly but differ in how the users' passwords are stored on the server and how the password provided by a cl… Password Hashing FunctionsManual ChaptersPG18pgcrypto — cryptographic functionsThe functions crypt() and gen_salt() are specifically designed for hashing passwords. crypt() does the hashing and gen_salt() prepares algorithm parameters for it. The algorithms in crypt() … password_profileExtensionsExtensionsSecurity · ExtensionsAdvanced password security and policy enforcement password_profile Security passwordcheckExtensionsPG18passwordcheck — verify password strengthverify password strength The passwordcheck module checks users' passwords whenever they are set with CREATE ROLE or ALTER ROLE. If a password is considered too weak, it will be rejected and … passwordcheck — verify password strengthManual ChaptersPG18The passwordcheck module checks users' passwords whenever they are set with CREATE ROLE or ALTER ROLE. If a password is considered too weak, it will be rejected and the command will terminat… passwordcheck_cracklibExtensionsExtensionsSecurity · ExtensionsStrengthen PostgreSQL user password checks with cracklib passwordcheck_cracklib Security passwordpolicyExtensionsExtensionsSecurity · ExtensionsDynamically configurable PostgreSQL password complexity checks. password security preload passwordpolicy Security pathData TypesPG18Data Typesgeometric path on a plane pathman_shardingExtensionsExtensionsAnalytics · ExtensionsImproved sharding for pg_pathman. fdw hash partitioning pathman range sharding pathman_sharding Analytics pathprobeExtensionsExtensionsMonitoring · ExtensionsPostgreSQL planner path probing extension for planner-aware SQL agents database hypothetical-indexes model-based-testing performance planner postgres postgres-extension postgresql query-opti… PathsManual ChaptersPG18Geometric Typesare represented by lists of connected points. Paths can be open, where the first and last points in the list are considered not connected, or closed, where the first and last points are cons… patientsExtensionsExtensionsFeatures · Extensionsextension dependency-closure patients source-only sql patients Features Pattern MatchingManual ChaptersPG18There are three separate approaches to pattern matching provided by PostgreSQL: the traditional SQL LIKE operator, the more recent SIMILAR TO operator (added in SQL:1999), and POSIX-style re… PatternsManual ChaptersPG18psqlThe various \d commands accept a pattern parameter to specify the object name(s) to be displayed. In the simplest case, a pattern is just the exact name of the object. The characters within … pavesExtensionsExtensionsAI and vectors · ExtensionsFiltered L2 vector search with CPU and optional GPU execution vector filtered-search gpu research paves AI and vectors payment_extExtensionsExtensionsFeatures · ExtensionsPayment-service transaction markers and a LISTEN/NOTIFY background worker for a marketplace prototype. payment_ext Features pbloompgExtensionsExtensionsFunctions and aggregates · Extensionsportable bloom filter, create, serialize, query across Go, Rust, Postgres pbloompg Functions and aggregates pboutputExtensionsExtensionsReplication and streams · ExtensionsBinary logical-decoding output plugin that encodes PostgreSQL changes as Protocol Buffers. pboutput Replication and streams pcg_randomExtensionsExtensionsFunctions and aggregates · ExtensionsPCG pseudo-random number generator functions for PostgreSQL. pgsql_pcg_random Functions and aggregates pcsa_counterExtensionsExtensionsFunctions and aggregates · ExtensionsAggregation functions and data type for distinct estimation based on PCSA. aggregate count distinct estimate pcsa sampling distinct_estimators Functions and aggregates PDFManual ChaptersPG18Building the Documentation with MakeTo produce a PDF rendition of the documentation using FOP, you can use one of the following commands, depending on the preferred paper format: For A4 format: doc/src/sgml$ make postgres-A4.p… ped25519ExtensionsExtensionsSecurity · ExtensionsEd25519 signing and verification functions implemented in Rust with pgrx. pgrx ped25519 Security Peer AuthenticationManual ChaptersPG18The peer authentication method works by obtaining the client's operating system user name from the kernel and using it as the allowed database user name (with optional user name mapping). Th… Per-Command PoliciesManual ChaptersPG18CREATE POLICYALL Using ALL for a policy means that it will apply to all commands, regardless of the type of command. If an ALL policy exists and more specific policies exist, then both the ALL policy and… Per-Statement ReportManual ChaptersPG18pgbenchWith the -r option, pgbench collects the following statistics for each statement: latency — elapsed transaction time for each statement. pgbench reports an average value of all successful ru… Per-Transaction LoggingManual ChaptersPG18pgbenchWith the -l option (but without the --aggregate-interval option), pgbench writes information about each transaction to a log file. The log file will be named prefix.nnn, where prefix default… percona_pg_telemetryExtensionsExtensionsMonitoring · ExtensionsPercona telemetry extension for PostgreSQL percona percona-distribution pg postgresql telemetry telemetry-collection percona_pg_telemetry Monitoring Performance TipsManual ChaptersPG18Query performance can be affected by many things. Some of these can be controlled by the user, while others are fundamental to the underlying design of the system. This chapter provides some… periodsExtensionsExtensionsTime series · ExtensionsProvide Standard SQL functionality for PERIODs and SYSTEM VERSIONING periods Time series permuteFunctionsPG18pgbench › Notes › Built-In Functions( i, size [, seed ] ) → integer Permuted value of i, in the range [0, size). This is the new position of i (modulo size) in a pseudorandom permutation of the integers 0...size-1, parameteriz… permuteseqExtensionsExtensionsFunctions and aggregates · ExtensionsPseudo-randomly permute sequences with a format-preserving encryption on elements permuteseq Functions and aggregates