1. gp_connections_per_thread: Sets the number of client connections handled in each thread. 2. gp_connection_send_timeout: controls the timeout value for sending data to unresponsive Greenplum Database user clients during query processing 1. gp_connections_per_thread [gpadmin@sachi ~]$ gpconfig -s gp_connections_per_thread Values on all segments are consistent GUC : gp_connections_per_thread Master value: 64 Segment value: 64 [gpadmin@sachi ~]$ gp_connections_per_thread default value was changed from 512 to 64 in GPDB 4.2 VALUE RANGE DEFAULT SET CLASSIFICATIONS integer 64 master, session, reload 2. gp_connection_send_timeout The Greenplum Database 4.3.4 server configuration parameter gp_connection_send_timeout controls the timeout value for sending data to unresponsive Greenplum Database user clients during query processing. When the timeout is reached, the query is cancelled. There few new Server Configuration Parameters have been introduced in Greenplum Database 4.3.4. • gp_connection_send_timeout • gp_create_table_random_default_distribution • gp_default_storage_options • pgcrypto.fips • runaway_detector_activation_percent gp_connection_send_timeout parameter sets Timeout for sending data to unresponsive Greenplum Database user clients during query processing. Avalue of 0 disables the timeout, Greenplum Database waits indefinitely for a client. When the timeout is reached, the query is cancelled with this message: Could not send data to client: Connection timed out. Value Range Default Set Classifications number of seconds 3600 (1 hour) master,system,reload |