Search PostgreSQL documentation

panda_postExtensionsExtensionsPython Pandas data in Postgres ndarray numpy python panda_post Replication and streamsReplication and streams · Extensions pandapostExtensionsExtensionsPython Pandas data in Postgres ndarray numpy python panda_post Replication and streamsReplication and streams · Extensions Parallel AggregationManual ChaptersPG1815.3.3. Parallel Aggregation PostgreSQL supports parallel aggregation by aggregating in two stages. First, each process participating in the parallel portion of the query performs an aggrega…Parallel Aggregation Parallel AppendManual ChaptersPG1815.3.4. Parallel Append Whenever PostgreSQL needs to combine rows from multiple sources into a single result set, it uses an Append or MergeAppend plan node. This commonly happens when imple…Parallel Append Parallel JoinsManual ChaptersPG1815.3.2. Parallel Joins Just as in a non-parallel plan, the driving table may be joined to one or more other tables using a nested loop, hash join, or merge join. The inner side of the join m…Parallel Joins Parallel Labeling for Functions and AggregatesManual ChaptersPG1815.4.1. Parallel Labeling for Functions and Aggregates The planner cannot automatically determine whether a user-defined function or aggregate is parallel safe, parallel restricted, or paral…Parallel Labeling for Functions and Aggregates Parallel Plan TipsManual ChaptersPG1815.3.5. Parallel Plan Tips If a query that is expected to do so does not produce a parallel plan, you can try reducing parallel_setup_cost or parallel_tuple_cost. Of course, this plan may tu…Parallel Plan Tips Parallel PlansManual ChaptersPG1815.3. Parallel Plans Because each worker executes the parallel portion of the plan to completion, it is not possible to simply take an ordinary query plan and run it using multiple workers. …Parallel Plans Parallel QueryManual ChaptersPG18Chapter 15. Parallel Query PostgreSQL can devise query plans that can leverage multiple CPUs in order to answer queries faster. This feature is known as parallel query. Many queries cannot b…Parallel Query Parallel SafetyManual ChaptersPG1815.4. Parallel Safety The planner classifies operations involved in a query as either parallel safe, parallel restricted, or parallel unsafe. A parallel safe operation is one that does not c…Parallel Safety Parallel ScansManual ChaptersPG1815.3.1. Parallel Scans The following types of parallel-aware table scans are currently supported. In a parallel sequential scan, the table's blocks will be divided into ranges and shared amo…Parallel Scans parallel_cloneExtensionsExtensionsPreloaded EPAS worker used by parallel schema cloning. schema clone parallel worker edb_cloneschema AdministrationAdministration · Extensions parallel_leader_participationConfigurationReferenceparallel_leader_participation Resource Usage 11 Allows the leader process to execute the query plan under Gather and Gather Merge nodes instead of waiting for worker processes. The default i…Configuration · Resource Usage parallel_setup_costConfigurationReferenceparallel_setup_cost Query Tuning 10 Sets the planner's estimate of the cost of launching parallel worker processes. The default is 1000. 11 12 13 14 15 16 17 18 19 20 9.6 parallel_setup_cost…Configuration · Query Tuning parallel_tuple_costConfigurationReferenceparallel_tuple_cost Query Tuning 10 Sets the planner's estimate of the cost of transferring one tuple from a parallel worker process to another process. The default is 0.1. 11 12 13 14 15 16…Configuration · Query Tuning ParallelAppendWait EventsReferenceParallelAppend LWLock 11 Waiting to choose the next subplan during Parallel Append plan execution. 12 13 14 15 16 17 18 19 20 A brief sample is normal around short internal critical sections…Wait Events · LWLock ParallelBitmapScanWait EventsReferenceParallelBitmapScan IPC 10 Waiting for parallel bitmap scan to become initialized. 11 12 13 14 15 16 17 18 19 20 Brief rendezvous is normal when every participant continues to advance. Invest…Wait Events · IPC ParallelBtreeScanWait EventsReferenceParallelBtreeScan LWLock 18 Waiting to synchronize workers during Parallel B-tree scan plan execution. 19 20 A brief sample is normal around short internal critical sections. Investigate whe…Wait Events · LWLock ParallelCreateIndexScanWait EventsReferenceParallelCreateIndexScan IPC 11 Waiting for parallel CREATE INDEX workers to finish heap scan. 12 13 14 15 16 17 18 19 20 Brief rendezvous is normal when every participant continues to advanc…Wait Events · IPC ParallelFinishWait EventsReferenceParallelFinish IPC 10 Waiting for parallel workers to finish computing. 11 12 13 14 15 16 17 18 19 20 Brief rendezvous is normal when every participant continues to advance. Investigate when…Wait Events · IPC ParallelHashJoinWait EventsReferenceParallelHashJoin LWLock 11 Waiting to allocate or exchange a chunk of memory or update counters during Parallel Hash plan execution. 12 13 Waiting to synchronize workers during Parallel Hash…Wait Events · LWLock ParallelQueryDSAWait EventsReferenceParallelQueryDSA LWLock 10 Waiting for parallel query dynamic shared memory allocation lock. 11 12 13 Waiting for parallel query dynamic shared memory allocation. 14 15 16 17 18 19 20 A brie…Wait Events · LWLock ParallelVacuumDSAWait EventsReferenceParallelVacuumDSA LWLock 17 Waiting for parallel vacuum dynamic shared memory allocation. 18 19 20 A brief sample is normal around short internal critical sections. Investigate when the same…Wait Events · LWLock Parameter Interaction via SQLManual ChaptersPG1819.1.3. Parameter Interaction via SQL PostgreSQL provides three SQL commands to establish configuration defaults. The already-mentioned ALTER SYSTEM command provides an SQL-accessible means …Parameter Interaction via SQL Parameter Interaction via the Configuration FileManual ChaptersPG1819.1.2. Parameter Interaction via the Configuration File The most fundamental way to set these parameters is to edit the file postgresql.conf, which is normally kept in the data directory. A…Parameter Interaction via the Configuration File Parameter Interaction via the ShellManual ChaptersPG1819.1.4. Parameter Interaction via the Shell In addition to setting global defaults or attaching overrides at the database or role level, you can pass settings to PostgreSQL via shell facilit…Parameter Interaction via the Shell Parameter Key WordsManual ChaptersPG1832.1.2. Parameter Key Words The currently recognized parameter key words are: host Name of host to connect to. If a host name looks like an absolute path name, it specifies Unix-domain commu…Parameter Key Words Parameter Names and ValuesManual ChaptersPG1819.1.1. Parameter Names and Values All parameter names are case-insensitive. Every parameter takes a value of one of five types: boolean, string, integer, floating point, or enumerated (enum…Parameter Names and Values ParametersManual ChaptersPG18F.6.1. Parameters A bloom index accepts the following parameters in its WITH clause: length Length of each signature (index entry) in bits. It is rounded up to the nearest multiple of 16. Th…Parameters ParametersManual ChaptersPG18Parameters name # A name of SQL descriptor, case sensitive. This can be an SQL identifier or a host variable.Parameters ParametersManual ChaptersPG18Parameters connection_target # connection_target specifies the target server of the connection on one of several forms. [ database_name ] [ @host ] [ :port ] # Connect over TCP/IP unix:postg…Parameters ParametersManual ChaptersPG18Parameters name # The name of the descriptor which is going to be deallocated. It is case sensitive. This can be an SQL identifier or a host variable.Parameters ParametersManual ChaptersPG18Parameters connection_name # A database connection name established by the CONNECT command. AT clause can be omitted, but such statement has no meaning. statement_name # The name of an SQL s…Parameters ParametersManual ChaptersPG18Parameters cursor_name # A cursor name, case sensitive. This can be an SQL identifier or a host variable. prepared_name # The name of a prepared query, either as an SQL identifier or a host …Parameters ParametersManual ChaptersPG18Parameters prepared_name # The name of a prepared statement. This can be an SQL identifier or a host variable. descriptor_name # A descriptor name. It is case sensitive. It can be an SQL ide…Parameters ParametersManual ChaptersPG18Parameters connection_name # A database connection name established by the CONNECT command. CURRENT # Close the “current” connection, which is either the most recently opened connection, or …Parameters ParametersManual ChaptersPG18Parameters string # A literal string or a host variable containing the SQL statement to be executed.Parameters ParametersManual ChaptersPG18Parameters descriptor_name # A descriptor name. descriptor_header_item # A token identifying which header information item to retrieve. Only COUNT, to get the number of columns in the result…Parameters ParametersManual ChaptersPG18Parameters cursor_name # The name of the cursor to be opened. This can be an SQL identifier or a host variable. value # A value to be bound to a placeholder in the cursor. This can be an SQL…Parameters ParametersManual ChaptersPG18Parameters prepared_name # An identifier for the prepared query. string # A literal string or a host variable containing a preparable SQL statement, one of SELECT, INSERT, UPDATE, or DELETE.…Parameters