We have migrated to new Google sites!
Post date: Jan 21, 2015 1:19:27 PM
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
A value larger than or equal to the number of primary segments means that each slice in a query plan will get its own thread when dispatching to the segments. A value of 0 indicates that the dispatcher should use a single thread when dispatching all query plan slices to a segment. Lower values will use more threads, which utilizes more resources on the master. Typically, the default does not need to be changed unless there is a known throughput performance problem.
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