GUCs for Improving Short Running Queries

Post date: Oct 31, 2014 1:26:36 PM

These GUCs are useful for queries that finish within less than 5 seconds and recommended to be used for OLTP-like workloads. Specifically helpful for systems that have large number of segments. Need to be tuned carefully in a high concurrency system. A system is high concurrency if resource queues are configured to run 50 or more queries concurrently.

1) gp_connections_per_thread

2. gp_enable_direct_dispatch

3. gp_cached_segworkers_threshold