Search PostgreSQL documentation

has_sequence_privilegeFunctionsReferencehas_sequence_privilege System Information Functions And Operators 10 does user have privilege for sequence has_sequence_privilege ( user, sequence, privilege ) → boolean does user have privi…Functions · System Information Functions And Operators has_server_privilegeFunctionsReferencehas_server_privilege System Information Functions And Operators 10 does user have privilege for foreign server has_server_privilege ( user, server, privilege ) → boolean does user have privi…Functions · System Information Functions And Operators has_table_privilegeFunctionsReferencehas_table_privilege System Information Functions And Operators 10 does user have privilege for table has_table_privilege ( user, table, privilege ) → boolean does user have privilege for tab…Functions · System Information Functions And Operators has_tablespace_privilegeFunctionsReferencehas_tablespace_privilege System Information Functions And Operators 10 does user have privilege for tablespace has_tablespace_privilege ( user, tablespace, privilege ) → boolean does user ha…Functions · System Information Functions And Operators has_type_privilegeFunctionsReferencehas_type_privilege System Information Functions And Operators 10 does user have privilege for type has_type_privilege ( user, type, privilege ) → boolean does user have privilege for type ha…Functions · System Information Functions And Operators hashExtensionsPG1865.6. Hash IndexesHash Indexes HashManual ChaptersPG1811.2.2. Hash Hash indexes store a 32-bit hash code derived from the value of the indexed column. Hence, such indexes can only handle simple equality comparisons. The query planner will consi…Hash hashFunctionsPG18hash ( value [, seed ] ) → integer This is an alias for hash_murmur2. hash(10, 5432) → -5817877081768721676pgbench › Notes › Built-In Functions Hash FunctionsManual ChaptersPG18F.23.7. Hash Functions hash_page_type(page bytea) returns text hash_page_type returns page type of the given HASH index page. For example: test=# SELECT hash_page_type(get_raw_page('con_hash…Hash Functions Hash IndexesManual ChaptersPG1865.6. Hash IndexesHash Indexes hash64ExtensionsExtensionsStable 64-bit hash function whose results do not change across PostgreSQL major versions. hashing partitioning sharding pg_hash64 Functions and aggregatesFunctions and aggregates · Extensions hash_fdwExtensionsExtensionsShared-memory hash-table foreign data wrapper for storing and querying rows by a configured key. fdw hash-table in-memory shared-memory hash_fdw Foreign data wrappersForeign data wrappers · Extensions hash_fnv1aFunctionsPG18hash_fnv1a ( value [, seed ] ) → integer Computes FNV-1a hash. hash_fnv1a(10, 5432) → -7793829335365542153pgbench › Notes › Built-In Functions hash_mem_multiplierConfigurationReferencehash_mem_multiplier Resource Usage 13 Used to compute the maximum amount of memory that hash-based operations can use. The final limit is determined by multiplying work_mem by hash_mem_multi…Configuration · Resource Usage hash_murmur2FunctionsPG18hash_murmur2 ( value [, seed ] ) → integer Computes MurmurHash2 hash. hash_murmur2(10, 5432) → -5817877081768721676pgbench › Notes › Built-In Functions HashBatchAllocateWait EventsReferenceHashBatchAllocate IPC 11 Waiting for an elected Parallel Hash participant to allocate a hash table. 12 13 14 15 16 17 18 19 20 Brief rendezvous is normal when every participant continues to …Wait Events · IPC HashBatchElectWait EventsReferenceHashBatchElect IPC 11 Electing a Parallel Hash participant to allocate a hash table. 12 13 Waiting to elect a Parallel Hash participant to allocate a hash table. 14 15 16 17 18 19 20 Brief r…Wait Events · IPC HashBatchLoadWait EventsReferenceHashBatchLoad IPC 11 Waiting for other Parallel Hash participants to finish loading a hash table. 12 13 14 15 16 17 18 19 20 Brief rendezvous is normal when every participant continues to ad…Wait Events · IPC HashBuildAllocateWait EventsReferenceHashBuildAllocate IPC 11 Waiting for an elected Parallel Hash participant to allocate the initial hash table. 12 13 14 15 16 17 18 19 20 Brief rendezvous is normal when every participant con…Wait Events · IPC HashBuildElectWait EventsReferenceHashBuildElect IPC 11 Electing a Parallel Hash participant to allocate the initial hash table. 12 13 Waiting to elect a Parallel Hash participant to allocate the initial hash table. 14 15 16…Wait Events · IPC HashBuildHashInnerWait EventsReferenceHashBuildHashInner IPC 11 Waiting for other Parallel Hash participants to finish hashing the inner relation. 12 13 14 15 16 17 18 19 20 Brief rendezvous is normal when every participant cont…Wait Events · IPC HashBuildHashOuterWait EventsReferenceHashBuildHashOuter IPC 11 Waiting for other Parallel Hash participants to finish partitioning the outer relation. 12 13 14 15 16 17 18 19 20 Brief rendezvous is normal when every participant…Wait Events · IPC HASHESManual ChaptersPG1836.15.5. HASHES The HASHES clause, if present, tells the system that it is permissible to use the hash join method for a join based on this operator. HASHES only makes sense for a binary ope…HASHES HashGrowBatchesDecideWait EventsReferenceHashGrowBatchesDecide IPC 11 Electing a Parallel Hash participant to decide on future batch growth. 12 13 Waiting to elect a Parallel Hash participant to decide on future batch growth. 14 15…Wait Events · IPC HashGrowBatchesElectWait EventsReferenceHashGrowBatchesElect IPC 11 Electing a Parallel Hash participant to allocate more batches. 12 13 Waiting to elect a Parallel Hash participant to allocate more batches. 14 15 16 17 18 19 20 B…Wait Events · IPC HashGrowBatchesFinishWait EventsReferenceHashGrowBatchesFinish IPC 11 Waiting for an elected Parallel Hash participant to decide on future batch growth. 12 13 14 15 16 17 18 19 20 Brief rendezvous is normal when every participant c…Wait Events · IPC HashGrowBatchesReallocateWait EventsReferenceHashGrowBatchesReallocate IPC 11 Waiting for an elected Parallel Hash participant to allocate more batches. 12 13 14 15 16 17 18 19 20 Brief rendezvous is normal when every participant conti…Wait Events · IPC HashGrowBatchesRepartitionWait EventsReferenceHashGrowBatchesRepartition IPC 11 Waiting for other Parallel Hash participants to finishing repartitioning. 12 13 Waiting for other Parallel Hash participants to finish repartitioning. 14 15…Wait Events · IPC HashGrowBucketsElectWait EventsReferenceHashGrowBucketsElect IPC 11 Electing a Parallel Hash participant to allocate more buckets. 12 13 Waiting to elect a Parallel Hash participant to allocate more buckets. 14 15 16 17 18 19 20 B…Wait Events · IPC HashGrowBucketsReallocateWait EventsReferenceHashGrowBucketsReallocate IPC 11 Waiting for an elected Parallel Hash participant to finish allocating more buckets. 12 13 14 15 16 17 18 19 20 Brief rendezvous is normal when every particip…Wait Events · IPC HashGrowBucketsReinsertWait EventsReferenceHashGrowBucketsReinsert IPC 11 Waiting for other Parallel Hash participants to finish inserting tuples into new buckets. 12 13 14 15 16 17 18 19 20 Brief rendezvous is normal when every part…Wait Events · IPC hashlibExtensionsExtensionsStable hash functions for Postgres pg_hashlib UtilitiesUtilities · Extensions hashsetExtensionsExtensionsProvides hashset type. hashset Data typesData types · Extensions hashtypesExtensionsExtensionssha1, md5 and other data types for PostgreSQL hashtypes Data typesData types · Extensions HAVINGSQL CommandsPG187.2.3. The GROUP BY and HAVING Clauses # After passing the WHERE filter, the derived input table might be subject to grouping, using the GROUP BY clause, and elimination of group rows using …Table Expressions › The GROUP BY and HAVING Clauses HAVING ClauseManual ChaptersPG18HAVING Clause The optional HAVING clause has the general form HAVING condition where condition is the same as specified for the WHERE clause. HAVING eliminates group rows that do not satisfy…HAVING Clause hba_fdwExtensionsExtensionsWork-in-progress foreign data wrapper scaffold intended to expose pg_hba.conf through SQL. authentication fdw pg-hba-conf wip hba_fdw Foreign data wrappersForeign data wrappers · Extensions hba_fileConfigurationReferencehba_file File Locations 10 Specifies the configuration file for host-based authentication (customarily called pg_hba.conf). This parameter can only be set at server start. 11 12 13 14 15 16 …Configuration · File Locations hbase_fdwExtensionsExtensionsForeign data wrapper for querying HBase from PostgreSQL. fdw hbase java hbase_fdw Foreign data wrappersForeign data wrappers · Extensions hclustExtensionsExtensionsC function for agglomerative or divisive hierarchical clustering that writes cluster assignments back to a table. clustering data-mining hierarchical-clustering spi hierarchicalclusteringfor…AI and vectors · Extensions