Search PostgreSQL documentation

LimitationsManual ChaptersPG18sepgsql — SELinux-, label-based mandatory access control (MAC) security moduleData Definition Language (DDL) Permissions Due to implementation restrictions, some DDL operations do not check permissions. Data Control Language (DCL) Permissions Due to implementation res… LimitationsManual ChaptersPG18The current limitations of PostgreSQL's text search features are: The length of each lexeme must be less than 2 kilobytes The length of a tsvector (lexemes + positions) must be less than 1 m… Limitations and Missing FeaturesManual ChaptersPG18PL/Perl Under the HoodThe following features are currently missing from PL/Perl, but they would make welcome contributions. PL/Perl functions cannot call each other directly. SPI is not yet fully implemented. If … Limitations of Functional DependenciesManual ChaptersPG18Statistics Used by the PlannerFunctional dependencies are currently only applied when considering simple equality conditions that compare columns to constant values, and IN clauses with constant values. They are not used… Limitations of PGP CodeManual ChaptersPG18pgcrypto — cryptographic functionsNo support for signing. That also means that it is not checked whether the encryption subkey belongs to the master key. No support for encryption key as master key. As such practice is gener… Limits and CompatibilityManual ChaptersPG18Pattern MatchingNo particular limit is imposed on the length of REs in this implementation. However, programs intended to be highly portable should not employ REs longer than 256 bytes, as a POSIX-compliant… Line SegmentsManual ChaptersPG18Geometric Typesare represented by pairs of points that are the endpoints of the segment. Values of type lseg are specified using any of the following syntaxes: [ ( x1 , y1 ) , ( x2 , y2 ) ] ( ( x1 , y1 ) ,… LinesManual ChaptersPG18Geometric Typesare represented by the linear equation Ax + By + C = 0, where A and B are not both zero. Values of type line are input and output in the following form: { A, B, C } Alternatively, any of the… Linux Huge PagesManual ChaptersPG18Managing Kernel ResourcesUsing huge pages reduces overhead when using large contiguous chunks of memory, as PostgreSQL does, particularly when using large values of shared_buffers. To use this feature in PostgreSQL … Linux Memory OvercommitManual ChaptersPG18Managing Kernel ResourcesThe default virtual memory behavior on Linux is not optimal for PostgreSQL. Because of the way that the kernel implements memory overcommit, the kernel might terminate the PostgreSQL postmas… lispgExtensionsExtensionsProcedural languages · ExtensionsLisp-like expression type and evaluator for PostgreSQL language lisp parser lispg Procedural languages LISTENManual ChaptersPG18for a notification Synopsis LISTEN channel livewireExtensionsExtensionsGeospatial · Extensionspower delivery modeling electric-grid pgrouting postgis routing livewire Geospatial ll_to_earthFunctionsPG18earthdistance — calculate great-circle distances › Cube-Based Earth Distances( float8, float8 ) → earth Returns the location of a point on the surface of the Earth given its latitude (argument 1) and longitude (argument 2) in degrees. llama_embedExtensionsExtensionsAI and vectors · Extensionsllama.cpp embedding extension for dense and multivector search bm25 hybrid hybrid-search pgvector postgres-extension postgresql rag retrieval turboquant vector-search llama_embed AI and vect… loExtensionsPG18lo — manage large objectsmanage large objects The lo module provides support for managing Large Objects (also called LOs or BLOBs). This includes a data type lo and a trigger lo_manage. This module is considered “tr… lo — manage large objectsManual ChaptersPG18The lo module provides support for managing Large Objects (also called LOs or BLOBs). This includes a data type lo and a trigger lo_manage. This module is considered “trusted”, that is, it c… lo_from_byteaFunctionsPG18Server-Side Functions( loid oid, data bytea ) → oid Creates a large object and stores data in it. If loid is zero then the system will choose a free OID, otherwise that OID is used (with an error if some large o… lo_getFunctionsPG18Server-Side Functions( loid oid [, offset bigint, length integer ] ) → bytea Extracts the large object's contents, or a substring thereof. lo_get(24528, 0, 3) → \xffaaff lo_putFunctionsPG18Server-Side Functions( loid oid, offset bigint, data bytea ) → void Writes data starting at the given offset within the large object; the large object is enlarged if necessary. lo_put(24528, 1, '\xaa') → LOADManual ChaptersPG18a shared library file Synopsis LOAD 'filename' Locale and EncodingManual ChaptersPG18Running the TestsBy default, tests using a temporary installation use the locale defined in the current environment and the corresponding database encoding as determined by initdb. It can be useful to test d… Locale and FormattingManual ChaptersPG18Client Connection DefaultsDateStyle (string) Sets the display format for date and time values, as well as the rules for interpreting ambiguous date input values. For historical reasons, this variable contains two ind… Locale Canonicalization and ValidationManual ChaptersPG18Locale SupportWhen defining a new ICU collation object or database with ICU as the provider, the given locale name is transformed ("canonicalized") into a language tag if not already in that form. For ins… Locale DifferencesManual ChaptersPG18Test EvaluationIf you run the tests against a server that was initialized with a collation-order locale other than C, then there might be differences due to sort order and subsequent failures. The regressi… Locale ProvidersManual ChaptersPG18Locale SupportA locale provider specifies which library defines the locale behavior for collations and character classifications. The commands and tools that select the locale settings, as described above… Locale SupportManual ChaptersPG18refers to an application respecting cultural preferences regarding alphabets, sorting, number formatting, etc. PostgreSQL uses the standard ISO C and POSIX locale facilities provided by the … LocalizationManual ChaptersPG18This chapter describes the available localization features from the point of view of the administrator. PostgreSQL supports two localization facilities: Using the locale features of the oper… localtimeSQL CommandsPG18Date/Time Functions and Operators→ time Current time of day; see Section 9.9.5 localtime → 14:39:53.662522 localtimestampSQL CommandsPG18Date/Time Functions and Operators→ timestamp Current date and time (start of current transaction); see Section 9.9.5 localtimestamp → 2019-12-23 14:39:53.662522 LOCKManual ChaptersPG18a table Synopsis LOCK [ TABLE ] [ ONLY ] name [ * ] [, ...] [ IN lockmode MODE ] [ NOWAIT ] where lockmode is one of: ACCESS SHARE | ROW SHARE | ROW EXCLUSIVE | SHARE UPDATE EXCLUSIVE | SHAR… Lock ManagementManual ChaptersPG18deadlock_timeout (integer) # This is the amount of time to wait on a lock before checking to see if there is a deadlock condition. The check for deadlock is relatively expensive, so the serv… Locking and IndexesManual ChaptersPG18Though PostgreSQL provides nonblocking read/write access to table data, nonblocking read/write access is not currently offered for every index access method implemented in PostgreSQL. The va… Log File MaintenanceManual ChaptersPG18It is a good idea to save the database server's log output somewhere, rather than just discarding it via /dev/null. The log output is invaluable when diagnosing problems. Note The server log… Log-Shipping Standby ServersManual ChaptersPG18Continuous archiving can be used to create a high availability (HA) cluster configuration with one or more standby servers ready to take over operations if the primary server fails. This cap… log_entriesExtensionsExtensionsSecurity · ExtensionsRow trigger that records who changed a row and when audit trigger log_entries Security log_fdwExtensionsExtensionsForeign data wrappers · Extensionsforeign-data wrapper for Postgres log file access log_fdw Foreign data wrappers log_functionsExtensionsExtensionsMonitoring · ExtensionsModule to log functions function log stored procedure log_functions Monitoring logerrorsExtensionsExtensionsSecurity · ExtensionsFunction for collecting statistics about messages in logfile logerrors Security logfmtExtensionsExtensionsMonitoring · Extensionslog collector log logging monitoring logfmt Monitoring