Search PostgreSQL documentation

bgwriter_delayConfigurationReferencebgwriter_delay Resource Usage 10 Specifies the delay between activity rounds for the background writer. In each round the writer issues writes for some number of dirty buffers (controllable …Configuration · Resource Usage bgwriter_flush_afterConfigurationReferencebgwriter_flush_after Resource Usage 10 Whenever more than bgwriter_flush_after bytes have been written by the background writer, attempt to force the OS to issue these writes to the underlyi…Configuration · Resource Usage bgwriter_lru_maxpagesConfigurationReferencebgwriter_lru_maxpages Resource Usage 10 In each round, no more than this many buffers will be written by the background writer. Setting this to zero disables background writing. (Note that c…Configuration · Resource Usage bgwriter_lru_multiplierConfigurationReferencebgwriter_lru_multiplier Resource Usage 10 The number of dirty buffers written in each round is based on the number of new buffers that have been needed by server processes during recent roun…Configuration · Resource Usage BgwriterHibernateWait EventsReferenceBgwriterHibernate Activity 10 Waiting in background writer process, hibernating. 11 12 13 14 15 16 17 18 19 20 This is normally expected idleness for the matching background process. Investi…Wait Events · Activity BgwriterMainWait EventsReferenceBgwriterMain Activity 10 Waiting in main loop of background writer process background worker. 11 12 13 Waiting in main loop of background writer process. 14 15 16 17 18 19 20 This is normall…Wait Events · Activity BibliographyManual ChaptersPG18Bibliography Selected references and readings for SQL and PostgreSQL. Some white papers and technical reports from the original POSTGRES development team are available at the University of C…Bibliography BibliographyManual ChaptersPG18F.20.6. Bibliography The information to implement this module was collected from several sites, including: https://www.isbn-international.org/ https://www.issn.org/ https://www.ismn-internat…Bibliography bigintData TypesPG18bigint int8 signed eight-byte integerData Types bigintarrayExtensionsExtensionsPostgres extension like intarray, but for bigints bigintarray Functions and aggregatesFunctions and aggregates · Extensions bignumExtensionsExtensionsUnlimited precision integers for PostgreSQL arbitrary-precision integer openssl type bignum Data typesData types · Extensions bigserialData TypesPG18bigserial serial8 autoincrementing eight-byte integerData Types bigtableExtensionsExtensionsRust PostgreSQL FDW for Google Bigtable bigtable fdw rust bigtable Foreign data wrappersForeign data wrappers · Extensions Binary Data TypesManual ChaptersPG188.4. Binary Data Types The bytea data type allows storage of binary strings; see Table 8.6. Table 8.6. Binary Data Types Name Storage Size Description bytea 1 or 4 bytes plus the actual bina…Binary Data Types Binary FormatManual ChaptersPG18Binary Format The binary format option causes all data to be stored/read as binary format rather than as text. It is somewhat faster than the text and CSV formats, but a binary-format file i…Binary Format Binary String Functions and OperatorsManual ChaptersPG189.5. Binary String Functions and Operators This section describes functions and operators for examining and manipulating binary strings, that is values of type bytea. Many of these are equiv…Binary String Functions and Operators binvecExtensionsExtensionsC helper for summing integer bit values into arrays aggregate binary-vector c binvec Functions and aggregatesFunctions and aggregates · Extensions biscuitExtensionsExtensionsIAM-LIKE pattern matching with bitmap indexing pg_biscuit Full-text searchFull-text search · Extensions bitData TypesPG18bit [ (n) ] fixed-length bit stringData Types Bit String Functions and OperatorsManual ChaptersPG189.6. Bit String Functions and Operators This section describes functions and operators for examining and manipulating bit strings, that is values of the types bit and bit varying. (While onl…Bit String Functions and Operators Bit String TypesManual ChaptersPG188.10. Bit String Types Bit strings are strings of 1's and 0's. They can be used to store or visualize bit masks. There are two SQL bit types: bit(n) and bit varying(n), where n is a positive…Bit String Types bit varyingData TypesPG18bit varying [ (n) ] varbit [ (n) ] variable-length bit stringData Types Bit-String ConstantsManual ChaptersPG184.1.2.5. Bit-String Constants Bit-string constants look like regular string constants with a B (upper or lower case) immediately before the opening quote (no intervening whitespace), e.g., B…Bit-String Constants bit_andFunctionsReferencebit_and Aggregate Functions 10 the bitwise AND of all non-null input values, or null if none bit_and ( expression ) → same as argument data type the bitwise AND of all non-null input values,…Functions · Aggregate Functions bit_countFunctionsReferencebit_count Binary String Functions And Operators 14 Returns the number of bits set in the binary string (also known as “popcount”). bit_count ( bytes bytea ) → bigint Returns the number of bi…Functions · Binary String Functions And Operators bit_lengthFunctionsReferencebit_length String Functions And Operators 10 Number of bits in string bit_length ( string ) → int Number of bits in string 11 12 13 Returns number of bits in the string (8 times the octet_le…Functions · String Functions And Operators bit_orFunctionsReferencebit_or Aggregate Functions 10 the bitwise OR of all non-null input values, or null if none bit_or ( expression ) → same as argument data type the bitwise OR of all non-null input values, or …Functions · Aggregate Functions bit_xorFunctionsReferencebit_xor Aggregate Functions 14 Computes the bitwise exclusive OR of all non-null input values. Can be useful as a checksum for an unordered set of values. bit_xor ( smallint ) → smallint Com…Functions · Aggregate Functions bitemp_retrievalExtensionsExtensionsRetrieval, coalescing, and join helpers for bitemporal tables created by pg_bitemporal. bitemp_retrieval Time seriesTime series · Extensions bitmap_counterExtensionsExtensionsAggregation functions and data type for distinct estimation based on s-bitmap. aggregate bitmap count distinct estimate self-learning distinct_estimators Functions and aggregatesFunctions and aggregates · Extensions bitpolar_pgExtensionsExtensionsBitPolar: near-optimal vector quantization — 3-8 bit compression with zero training. 58 integrations across every major AI framework. bitpolar_pg AI and vectorsAI and vectors · Extensions bitstring_helpersExtensionsExtensionsHelper C functions and aggregates for PostgreSQL bit varying data. bit-string hamming-distance bitstring_helpers Functions and aggregatesFunctions and aggregates · Extensions BKI CommandsManual ChaptersPG1868.4. BKI Commands create tablename tableoid [bootstrap] [shared_relation] [rowtype_oid oid] (name1 = type1 [FORCE NOT NULL | FORCE NULL ] [, name2 = type2 [FORCE NOT NULL | FORCE NULL ], ..…BKI Commands BKI ExampleManual ChaptersPG1868.6. BKI Example The following sequence of commands will create the table test_table with OID 420, having three columns oid, cola and colb of type oid, int4 and text, respectively, and inse…BKI Example BKI File FormatManual ChaptersPG1868.3. BKI File Format This section describes how the PostgreSQL backend interprets BKI files. This description will be easier to understand if the postgres.bki file is at hand as an example.…BKI File Format bktreeExtensionsExtensionsSP-GiST BK-tree index extension for 64-bit perceptual hashes and Hamming-distance searches. bk-tree hamming-distance index spgist bktree AI and vectorsAI and vectors · Extensions blake2bExtensionsExtensionsPostgreSQL extension for fast secure hashing blake2b cardano cryptography postgresql-extension blake2b SecuritySecurity · Extensions block_copy_commandExtensionsExtensionsBlock COPY commands via a configurable ProcessUtility hook pgrx block_copy_command SecuritySecurity · Extensions block_sizeConfigurationReferenceblock_size Preset Options 10 Reports the size of a disk block. It is determined by the value of BLCKSZ when building the server. The default value is 8192 bytes. The meaning of some configur…Configuration · Preset Options bloomExtensionsPG18F.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