Search PostgreSQL documentation

bloom — bloom filter index access methodManual ChaptersPG18F.6. bloom — bloom filter index access method bloom provides an index access method based on Bloom filters. A Bloom filter is a space-efficient data structure that is used to test whether an…bloom — bloom filter index access method bloom_fulonExtensionsExtensionsExperimental pgrx index access method for PostgreSQL, created for learning purposes. experimental index pgrx bloom_fulon FeaturesFeatures · Extensions bloompgExtensionsExtensionsPlanner-hook extension for PostgreSQL 18 that prefilters equality-join inputs with adaptive Bloom or exact bitmap transfer before replanning analytical queries. analytics bloom-filter join-o…Features · Extensions bluefinExtensionsExtensionsAppend-only compressed table access method for time-series workloads. table-am columnar compression timeseries advanced_storage_pack AnalyticsAnalytics · Extensions bobbie@helloExtensionsExtensionsAn extension to generate greetings database.dev tle bobbie@hello Functions and aggregatesFunctions and aggregates · Extensions bonjourConfigurationReferencebonjour Connections and Authentication 10 Enables advertising the server's existence via Bonjour. The default is off. This parameter can only be set at server start. 11 12 13 14 15 16 17 18 …Configuration · Connections and Authentication bonjour_nameConfigurationReferencebonjour_name Connections and Authentication 10 Specifies the Bonjour service name. The computer name is used if this parameter is set to the empty string '' (which is the default). This para…Configuration · Connections and Authentication bool_andFunctionsReferencebool_and Aggregate Functions 10 true if all input values are true, otherwise false bool_and ( expression ) → bool true if all input values are true, otherwise false 11 12 13 Returns true if …Functions · Aggregate Functions bool_orFunctionsReferencebool_or Aggregate Functions 10 true if at least one input value is true, otherwise false bool_or ( expression ) → bool true if at least one input value is true, otherwise false 11 12 13 Retu…Functions · Aggregate Functions bool_plperlExtensionsExtensionstransform between bool and plperl plperl Procedural languagesProcedural languages · Extensions bool_plperluExtensionsExtensionstransform between bool and plperlu plperlu Procedural languagesProcedural languages · Extensions booleanData TypesPG18boolean bool logical Boolean (true/false)Data Types Boolean Predicate Check ExpressionsManual ChaptersPG189.16.2.1.1. Boolean Predicate Check Expressions As an extension to the SQL standard, a PostgreSQL path expression can be a Boolean predicate, whereas the SQL standard allows predicates only …Boolean Predicate Check Expressions Boolean TypeManual ChaptersPG188.6. Boolean Type PostgreSQL provides the standard SQL type boolean; see Table 8.19. The boolean type can have several states: “true”, “false”, and a third state, “unknown”, which is represe…Boolean Type boolean_cascadedExtensionsExtensionsComposite boolean status type with operators and trigger helper for cascaded parent-child status. boolean data-type trigger boolean_cascaded Data typesData types · Extensions Bottom-up Index DeletionManual ChaptersPG1865.1.4.2. Bottom-up Index Deletion B-Tree indexes are not directly aware that under MVCC, there might be multiple extant versions of the same logical table row; to an index, each tuple is an…Bottom-up Index Deletion bound_boxFunctionsReferencebound_box Geometric Functions And Operators 10 boxes to bounding box bound_box ( box, box ) → box boxes to bounding box 11 12 13 Computes bounding box of two boxes. bound_box ( box, box ) → …Functions · Geometric Functions And Operators boxData TypesPG18box rectangular box on a planeData Types boxFunctionsReferencebox Geometric Functions And Operators 10 circle to box box ( circle ) → box circle to box box ( point ) → box point to empty box box ( point, point ) → box points to box box ( polygon ) → bo…Functions · Geometric Functions And Operators BoxesManual ChaptersPG188.8.4. Boxes Boxes are represented by pairs of points that are opposite corners of the box. Values of type box are specified using any of the following syntaxes: ( ( x1 , y1 ) , ( x2 , y2 ) …Boxes Bracket ExpressionsManual ChaptersPG189.7.3.2. Bracket Expressions A bracket expression is a list of characters enclosed in []. It normally matches any single character from the list (but see below). If the list begins with ^, i…Bracket Expressions brainfuckExtensionsExtensionsRun Brainfuck programs inside PostgreSQL using a PLV8 trusted language extension. brainfuck plv8 tle brainfuck Procedural languagesProcedural languages · Extensions brinExtensionsPG1865.5. BRIN IndexesBRIN Indexes BRINManual ChaptersPG1811.2.6. BRIN BRIN indexes (a shorthand for Block Range INdexes) store summaries about the values stored in consecutive physical block ranges of a table. Thus, they are most effective for col…BRIN BRIN FunctionsManual ChaptersPG18F.23.4. BRIN Functions brin_page_type(page bytea) returns text brin_page_type returns the page type of the given BRIN index page, or throws an error if the page is not a valid BRIN page. For…BRIN Functions BRIN IndexesManual ChaptersPG1865.5. BRIN IndexesBRIN Indexes brin4postgisExtensionsExtensionsBRIN indexes for PostGIS brin experimental geometry index postgis brin4postgis GeospatialGeospatial · Extensions brin_desummarize_rangeFunctionsReferencebrin_desummarize_range System Administration Functions 10 de-summarize the page range covering the given block, if summarized brin_desummarize_range ( index regclass, blockNumber bigint ) → …Functions · System Administration Functions brin_summarize_new_valuesFunctionsReferencebrin_summarize_new_values System Administration Functions 10 summarize page ranges not already summarized brin_summarize_new_values ( index regclass ) → integer summarize page ranges not alr…Functions · System Administration Functions brin_summarize_rangeFunctionsReferencebrin_summarize_range System Administration Functions 10 summarize the page range covering the given block, if not already summarized brin_summarize_range ( index regclass, blockNumber bigint…Functions · System Administration Functions broadcastFunctionsReferencebroadcast Network Address Functions And Operators 10 broadcast address for network broadcast ( inet ) → inet broadcast address for network 11 12 13 Computes the broadcast address for the add…Functions · Network Address Functions And Operators BSD AuthenticationManual ChaptersPG1820.14. BSD Authentication This authentication method operates similarly to password except that it uses BSD Authentication to verify the password. BSD Authentication is used only to validate…BSD Authentication btreeExtensionsPG1865.1. B-Tree IndexesB-Tree Indexes btree_ginExtensionsPG18F.7. btree_gin — GIN operator classes with B-tree behavior btree_gin provides GIN operator classes that implement B-tree equivalent behavior for the data types int2, int4, int8, float4, floa…btree_gin — GIN operator classes with B-tree behavior btree_gin — GIN operator classes with B-tree behaviorManual ChaptersPG18F.7. btree_gin — GIN operator classes with B-tree behavior btree_gin provides GIN operator classes that implement B-tree equivalent behavior for the data types int2, int4, int8, float4, floa…btree_gin — GIN operator classes with B-tree behavior btree_gistExtensionsPG18F.8. btree_gist — GiST operator classes with B-tree behavior btree_gist provides GiST index operator classes that implement B-tree equivalent behavior for the data types int2, int4, int8, fl…btree_gist — GiST operator classes with B-tree behavior btree_gist — GiST operator classes with B-tree behaviorManual ChaptersPG18F.8. btree_gist — GiST operator classes with B-tree behavior btree_gist provides GiST index operator classes that implement B-tree equivalent behavior for the data types int2, int4, int8, fl…btree_gist — GiST operator classes with B-tree behavior BtreePageWait EventsReferenceBtreePage IPC 10 Waiting for the page number needed to continue a parallel B-tree scan to become available. 11 12 13 14 15 16 17 18 19 20 Brief rendezvous is normal when every participant co…Wait Events · IPC BtreeVacuumWait EventsReferenceBtreeVacuum LWLock 10 Waiting to read or update vacuum-related information for a B-tree index. 11 12 13 14 15 16 17 18 19 20 9.6 A brief sample is normal around short internal critical secti…Wait Events · LWLock btrimFunctionsReferencebtrim String Functions And Operators 10 Remove the longest string consisting only of characters in characters (a space by default) from the start and end of string btrim ( string text [, cha…Functions · String Functions And Operators