forked from vmware-archive/docs-hd-staging
-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathHAWQServerConfigurationParameters.html
812 lines (736 loc) · 199 KB
/
HAWQServerConfigurationParameters.html
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
783
784
785
786
787
788
789
790
791
792
793
794
795
796
797
798
799
800
801
802
803
804
805
806
807
808
809
810
811
812
<!doctype html>
<html>
<head>
<meta charset="utf-8">
<!-- Always force latest IE rendering engine or request Chrome Frame -->
<meta content="IE=edge,chrome=1" http-equiv="X-UA-Compatible">
<!-- REPLACE X WITH PRODUCT NAME -->
<title>HAWQ Server Configuration Parameters | Pivotal Docs</title>
<!-- Local CSS stylesheets -->
<link href="/stylesheets/master.css" media="screen,print" rel="stylesheet" type="text/css" />
<link href="/stylesheets/breadcrumbs.css" media="screen,print" rel="stylesheet" type="text/css" />
<link href="/stylesheets/search.css" media="screen,print" rel="stylesheet" type="text/css" />
<link href="/stylesheets/portal-style.css" media="screen,print" rel="stylesheet" type="text/css" />
<link href="/stylesheets/printable.css" media="print" rel="stylesheet" type="text/css" />
<!-- Confluence HTML stylesheet -->
<link href="/stylesheets/site-conf.css" media="screen,print" rel="stylesheet" type="text/css" />
<!-- Left-navigation code -->
<!-- http://www.designchemical.com/lab/jquery-vertical-accordion-menu-plugin/examples/# -->
<link href="/stylesheets/dcaccordion.css" rel="stylesheet" type="text/css" />
<script src="http://ajax.googleapis.com/ajax/libs/jquery/1.4.2/jquery.min.js" type="text/javascript"></script>
<script src="/javascripts/jquery.cookie.js" type="text/javascript"></script>
<script src="/javascripts/jquery.hoverIntent.minified.js" type="text/javascript"></script>
<script src="/javascripts/jquery.dcjqaccordion.2.7.min.js" type="text/javascript"></script>
<script type="text/javascript">
$(document).ready(function($){
$('#accordion-1').dcAccordion({
eventType: 'click',
autoClose: true,
saveState: true,
disableLink: false,
speed: 'fast',
classActive: 'test',
showCount: false
});
});
</script>
<link href="/stylesheets/grey.css" rel="stylesheet" type="text/css" />
<!-- End left-navigation code -->
<script src="/javascripts/all.js" type="text/javascript"></script>
<link href='http://www.gopivotal.com/misc/favicon.ico' rel='shortcut icon'>
<script type="text/javascript">
if (window.location.host === 'docs.gopivotal.com') {
var _gaq = _gaq || [];
_gaq.push(['_setAccount', 'UA-39702075-1']);
_gaq.push(['_setDomainName', 'gopivotal.com']);
_gaq.push(['_trackPageview']);
(function() {
var ga = document.createElement('script'); ga.type = 'text/javascript'; ga.async = true;
ga.src = ('https:' == document.location.protocol ? 'https://ssl' : 'http://www') + '.google-analytics.com/ga.js';
var s = document.getElementsByTagName('script')[0]; s.parentNode.insertBefore(ga, s);
})();
}
</script>
</head>
<body class="pivotalcf pivotalcf_getstarted pivotalcf_getstarted_index">
<div class="viewport">
<div class="mobile-navigation--wrapper mobile-only">
<div class="navigation-drawer--container">
<div class="navigation-item-list">
<div class="navbar-link active">
<a href="http://gopivotal.com">
Home
<i class="icon-chevron-right pull-right"></i>
</a>
</div>
<div class="navbar-link">
<a href="http://gopivotal.com/paas">
PaaS
<i class="icon-chevron-right pull-right"></i>
</a>
</div>
<div class="navbar-link">
<a href="http://gopivotal.com/big-data">
Big Data
<i class="icon-chevron-right pull-right"></i>
</a>
</div>
<div class="navbar-link">
<a href="http://gopivotal.com/agile">
Agile
<i class="icon-chevron-right pull-right"></i>
</a>
</div>
<div class="navbar-link">
<a href="http://gopivotal.com/support">
Help & Support
<i class="icon-chevron-right pull-right"></i>
</a>
</div>
<div class="navbar-link">
<a href="http://gopivotal.com/products">
Products
<i class="icon-chevron-right pull-right"></i>
</a>
</div>
<div class="navbar-link">
<a href="http://gopivotal.com/solutions">
Solutions
<i class="icon-chevron-right pull-right"></i>
</a>
</div>
<div class="navbar-link">
<a href="http://gopivotal.com/partners">
Partners
<i class="icon-chevron-right pull-right"></i>
</a>
</div>
</div>
</div>
<div class="mobile-nav">
<div class="nav-icon js-open-nav-drawer">
<i class="icon-reorder"></i>
</div>
<div class="header-center-icon">
<a href="http://gopivotal.com">
<div class="icon icon-pivotal-logo-mobile"></div>
</a>
</div>
</div>
</div>
<div class='wrap'>
<script src="//use.typekit.net/clb0qji.js" type="text/javascript"></script>
<script type="text/javascript">
try {
Typekit.load();
} catch (e) {
}
</script>
<script type="text/javascript">
document.domain = "gopivotal.com";
</script>
<script type="text/javascript">
WebFontConfig = {
google: { families: [ 'Source+Sans+Pro:300italic,400italic,600italic,300,400,600:latin' ] }
};
(function() {
var wf = document.createElement('script');
wf.src = ('https:' == document.location.protocol ? 'https' : 'http') +
'://ajax.googleapis.com/ajax/libs/webfont/1/webfont.js';
wf.type = 'text/javascript';
wf.async = 'true';
var s = document.getElementsByTagName('script')[0];
s.parentNode.insertBefore(wf, s);
})(); </script>
<div id="search-dropdown-box">
<div class="search-dropdown--container js-search-dropdown">
<div class="container-fluid">
<div class="close-menu-large"><img src="http://www.gopivotal.com/sites/all/themes/gopo13/images/icon-close.png" /></div>
<div class="search-form--container">
<div class="form-search">
<div class='gcse-search'></div>
<script src="http://www.google.com/jsapi" type="text/javascript"></script>
<script src="/javascripts/cse.js" type="text/javascript"></script>
</div>
</div>
</div>
</div>
</div>
<header class="navbar desktop-only" id="nav">
<div class="navbar-inner">
<div class="container-fluid">
<div class="pivotal-logo--container">
<a class="pivotal-logo" href="http://gopivotal.com"><span></span></a>
</div>
<ul class="nav pull-right">
<li class="navbar-link">
<a href="http://www.gopivotal.com/paas" id="paas-nav-link">PaaS</a>
</li>
<li class="navbar-link">
<a href="http://www.gopivotal.com/big-data" id="big-data-nav-link">BIG DATA</a>
</li>
<li class="navbar-link">
<a href="http://www.gopivotal.com/agile" id="agile-nav-link">AGILE</a>
</li>
<li class="navbar-link">
<a href="http://www.gopivotal.com/oss" id="oss-nav-link">OSS</a>
</li>
<li class="nav-search">
<a class="js-search-input-open" id="click-to-search"><span></span></a>
</li>
</ul>
</div>
<a href="http://www.gopivotal.com/contact">
<img id="get-started" src="http://www.gopivotal.com/sites/all/themes/gopo13/images/get-started.png">
</a>
</div>
</header>
<div class="main-wrap">
<div class="container-fluid">
<!-- Google CSE Search Box -->
<div id='docs-search'>
<gcse:search></gcse:search>
</div>
<div id='all-docs-link'>
<a href="http://docs.gopivotal.com/">All Documentation</a>
</div>
<div class="container">
<div id="sub-nav" class="nav-container">
<!-- Collapsible left-navigation-->
<ul class="accordion" id="accordion-1">
<!-- REPLACE <li/> NODES-->
<li>
<a href="index.html">Home</a></br>
<li>
<a href="PivotalHD.html">Pivotal HD 2.0.1</a>
<ul>
<li>
<a href="PHDEnterprise2.0.1ReleaseNotes.html">PHD Enterprise 2.0.1 Release Notes</a>
</li>
</ul>
<ul>
<li>
<a href="PHDInstallationandAdministration.html">PHD Installation and Administration</a>
<ul>
<li>
<a href="OverviewofPHD.html">Overview of PHD</a>
</li>
</ul>
<ul>
<li>
<a href="InstallationOverview.html">Installation Overview</a>
</li>
</ul>
<ul>
<li>
<a href="PHDInstallationChecklist.html">PHD Installation Checklist</a>
</li>
</ul>
<ul>
<li>
<a href="InstallingPHDUsingtheCLI.html">Installing PHD Using the CLI</a>
</li>
</ul>
<ul>
<li>
<a href="UpgradeChecklist.html">Upgrade Checklist</a>
</li>
</ul>
<ul>
<li>
<a href="UpgradingPHDUsingtheCLI.html">Upgrading PHD Using the CLI</a>
</li>
</ul>
<ul>
<li>
<a href="AdministeringPHDUsingtheCLI.html">Administering PHD Using the CLI</a>
</li>
</ul>
<ul>
<li>
<a href="PHDFAQFrequentlyAskedQuestions.html">PHD FAQ (Frequently Asked Questions)</a>
</li>
</ul>
<ul>
<li>
<a href="PHDTroubleshooting.html">PHD Troubleshooting</a>
</li>
</ul>
</li>
</ul>
<ul>
<li>
<a href="StackandToolsReference.html">Stack and Tools Reference</a>
<ul>
<li>
<a href="OverviewofApacheStackandPivotalComponents.html">Overview of Apache Stack and Pivotal Components</a>
</li>
</ul>
<ul>
<li>
<a href="ManuallyInstallingPivotalHD2.0Stack.html">Manually Installing Pivotal HD 2.0 Stack</a>
</li>
</ul>
<ul>
<li>
<a href="ManuallyUpgradingPivotalHDStackfrom1.1.1to2.0.html">Manually Upgrading Pivotal HD Stack from 1.1.1 to 2.0</a>
</li>
</ul>
<ul>
<li>
<a href="PivotalHadoopEnhancements.html">Pivotal Hadoop Enhancements</a>
</li>
</ul>
<ul>
<li>
<a href="Security.html">Security</a>
</li>
</ul>
</li>
</ul>
</li>
<li>
<a href="PivotalCommandCenter.html">Pivotal Command Center 2.2.1</a>
<ul>
<li>
<a href="PCC2.2.1ReleaseNotes.html">PCC 2.2.1 Release Notes</a>
</li>
</ul>
<ul>
<li>
<a href="PCCUserGuide.html">PCC User Guide</a>
<ul>
<li>
<a href="PCCOverview.html">PCC Overview</a>
</li>
</ul>
<ul>
<li>
<a href="PCCInstallationChecklist.html">PCC Installation Checklist</a>
</li>
</ul>
<ul>
<li>
<a href="InstallingPCC.html">Installing PCC</a>
</li>
</ul>
<ul>
<li>
<a href="UsingPCC.html">Using PCC</a>
</li>
</ul>
<ul>
<li>
<a href="CreatingaYUMEPELRepository.html">Creating a YUM EPEL Repository</a>
</li>
</ul>
<ul>
<li>
<a href="CommandLineReference.html">Command Line Reference</a>
</li>
</ul>
</li>
</ul>
</li>
<li>
<a href="PivotalHAWQ.html">Pivotal HAWQ 1.2.0</a>
<ul>
<li>
<a href="HAWQ1.2.0.1ReleaseNotes.html">HAWQ 1.2.0.1 Release Notes</a>
</li>
</ul>
<ul>
<li>
<a href="HAWQInstallationandUpgrade.html">HAWQ Installation and Upgrade</a>
<ul>
<li>
<a href="PreparingtoInstallHAWQ.html">Preparing to Install HAWQ</a>
</li>
</ul>
<ul>
<li>
<a href="InstallingHAWQ.html">Installing HAWQ</a>
</li>
</ul>
<ul>
<li>
<a href="InstallingtheHAWQComponents.html">Installing the HAWQ Components</a>
</li>
</ul>
<ul>
<li>
<a href="UpgradingHAWQandComponents.html">Upgrading HAWQ and Components</a>
</li>
</ul>
<ul>
<li>
<a href="HAWQConfigurationParameterReference.html">HAWQ Configuration Parameter Reference</a>
</li>
</ul>
</li>
</ul>
<ul>
<li>
<a href="HAWQAdministration.html">HAWQ Administration</a>
<ul>
<li>
<a href="HAWQOverview.html">HAWQ Overview</a>
</li>
</ul>
<ul>
<li>
<a href="HAWQQueryProcessing.html">HAWQ Query Processing</a>
</li>
</ul>
<ul>
<li>
<a href="UsingHAWQtoQueryData.html">Using HAWQ to Query Data</a>
</li>
</ul>
<ul>
<li>
<a href="ConfiguringClientAuthentication.html">Configuring Client Authentication</a>
</li>
</ul>
<ul>
<li>
<a href="KerberosAuthentication.html">Kerberos Authentication</a>
</li>
</ul>
<ul>
<li>
<a href="ExpandingtheHAWQSystem.html">Expanding the HAWQ System</a>
</li>
</ul>
<ul>
<li>
<a href="HAWQInputFormatforMapReduce.html">HAWQ InputFormat for MapReduce</a>
</li>
</ul>
<ul>
<li>
<a href="HAWQFilespacesandHighAvailabilityEnabledHDFS.html">HAWQ Filespaces and High Availability Enabled HDFS</a>
</li>
</ul>
<ul>
<li>
<a href="SQLCommandReference.html">SQL Command Reference</a>
</li>
</ul>
<ul>
<li>
<a href="ManagementUtilityReference.html">Management Utility Reference</a>
</li>
</ul>
<ul>
<li>
<a href="ClientUtilityReference.html">Client Utility Reference</a>
</li>
</ul>
<ul>
<li>
<a href="HAWQServerConfigurationParameters.html">HAWQ Server Configuration Parameters</a>
</li>
</ul>
<ul>
<li>
<a href="HAWQEnvironmentVariables.html">HAWQ Environment Variables</a>
</li>
</ul>
<ul>
<li>
<a href="HAWQDataTypes.html">HAWQ Data Types</a>
</li>
</ul>
<ul>
<li>
<a href="SystemCatalogReference.html">System Catalog Reference</a>
</li>
</ul>
<ul>
<li>
<a href="hawq_toolkitReference.html">hawq_toolkit Reference</a>
</li>
</ul>
</li>
</ul>
<ul>
<li>
<a href="PivotalExtensionFrameworkPXF.html">Pivotal Extension Framework (PXF)</a>
<ul>
<li>
<a href="PXFInstallationandAdministration.html">PXF Installation and Administration</a>
</li>
</ul>
<ul>
<li>
<a href="PXFExternalTableandAPIReference.html">PXF External Table and API Reference</a>
</li>
</ul>
</div><!--end of sub-nav-->
<h3 class="title-container">HAWQ Server Configuration Parameters</h3>
<div class="content">
<!-- Python script replaces main content -->
<div id ="main"><div style="visibility:hidden; height:2px;">Pivotal Product Documentation : HAWQ Server Configuration Parameters</div><div class="wiki-content group" id="main-content">
<p align="LEFT">There are many configuration parameters that affect the behavior of the HAWQ system. Many of these configuration parameters have the same names, settings, and behaviors as in a regular PostgreSQL database system.</p><p align="LEFT"><style type="text/css">/*<![CDATA[*/
div.rbtoc1400035795374 {padding: 0px;}
div.rbtoc1400035795374 ul {list-style: disc;margin-left: 0px;}
div.rbtoc1400035795374 li {margin-left: 0px;padding-left: 0px;}
/*]]>*/</style><div class="toc-macro rbtoc1400035795374">
<ul class="toc-indentation">
<li><a href="#HAWQServerConfigurationParameters-ParameterTypesandValues">Parameter Types and Values</a></li>
<li><a href="#HAWQServerConfigurationParameters-SettingParameters">Setting Parameters</a></li>
<li><a href="#HAWQServerConfigurationParameters-ServerConfigurationParameters">Server Configuration Parameters</a>
<ul class="toc-indentation">
<li><a href="#HAWQServerConfigurationParameters-add_missing_from">add_missing_from</a></li>
<li><a href="#HAWQServerConfigurationParameters-application">application</a></li>
<li><a href="#HAWQServerConfigurationParameters-array_null">array_null</a></li>
<li><a href="#HAWQServerConfigurationParameters-authentication_timeout">authentication_timeout</a></li>
<li><a href="#HAWQServerConfigurationParameters-backslash_quote">backslash_quote</a></li>
<li><a href="#HAWQServerConfigurationParameters-block_size">block_size</a></li>
<li><a href="#HAWQServerConfigurationParameters-bonjour_name">bonjour_name</a></li>
<li><a href="#HAWQServerConfigurationParameters-check_functionbodies">check_function bodies</a></li>
<li><a href="#HAWQServerConfigurationParameters-client_encoding">client_encoding</a></li>
<li><a href="#HAWQServerConfigurationParameters-client_min_messages">client_min_messages</a></li>
<li><a href="#HAWQServerConfigurationParameters-cpu_operator_cost">cpu_operator_cost</a></li>
<li><a href="#HAWQServerConfigurationParameters-cpu_tuple_cost">cpu_tuple_cost</a></li>
<li><a href="#HAWQServerConfigurationParameters-cursor_tuple_fraction">cursor_tuple_fraction</a></li>
<li><a href="#HAWQServerConfigurationParameters-cursor_tuple_fraction.1">cursor_tuple_fraction</a></li>
<li><a href="#HAWQServerConfigurationParameters-DataStyle">DataStyle</a></li>
<li><a href="#HAWQServerConfigurationParameters-db_user_namespace">db_user_namespace</a></li>
<li><a href="#HAWQServerConfigurationParameters-deadlock_timeout">deadlock_timeout</a></li>
<li><a href="#HAWQServerConfigurationParameters-debug_assertions">debug_assertions</a></li>
<li><a href="#HAWQServerConfigurationParameters-debug_pretty_print">debug_pretty_print</a></li>
<li><a href="#HAWQServerConfigurationParameters-debug_print_parse">debug_print_parse</a></li>
<li><a href="#HAWQServerConfigurationParameters-debug_print_plan">debug_print_plan</a></li>
<li><a href="#HAWQServerConfigurationParameters-debug_print_prelim_plan">debug_print_prelim_plan</a></li>
<li><a href="#HAWQServerConfigurationParameters-gp_autostats_mode">gp_autostats_mode</a></li>
<li><a href="#HAWQServerConfigurationParameters-gp_autostats_on_change_threshold">gp_autostats_on_change_threshold</a></li>
<li><a href="#HAWQServerConfigurationParameters-gp_cached_segworkers_threshold">gp_cached_segworkers_threshold</a></li>
<li><a href="#HAWQServerConfigurationParameters-gp_command_count">gp_command_count</a></li>
<li><a href="#HAWQServerConfigurationParameters-gp_connectemc_mode">gp_connectemc_mode</a></li>
<li><a href="#HAWQServerConfigurationParameters-gp_connections_per_thread">gp_connections_per_thread</a></li>
<li><a href="#HAWQServerConfigurationParameters-gp_content">gp_content</a></li>
<li><a href="#HAWQServerConfigurationParameters-gp_dbid">gp_dbid </a></li>
<li><a href="#HAWQServerConfigurationParameters-gp_debug_linger">gp_debug_linger</a></li>
<li><a href="#HAWQServerConfigurationParameters-gp_dynamic_partition_pruning">gp_dynamic_partition_pruning</a></li>
<li><a href="#HAWQServerConfigurationParameters-gp_email_from">gp_email_from</a></li>
<li><a href="#HAWQServerConfigurationParameters-gp_email_smtp_password">gp_email_smtp_password</a></li>
<li><a href="#HAWQServerConfigurationParameters-gp_email_smtp_server">gp_email_smtp_server</a></li>
<li><a href="#HAWQServerConfigurationParameters-gp_email_smtp_userid">gp_email_smtp_userid</a></li>
<li><a href="#HAWQServerConfigurationParameters-gp_email_to">gp_email_to</a></li>
<li><a href="#HAWQServerConfigurationParameters-gp_enable_adaptive_nestloop">gp_enable_adaptive_nestloop</a></li>
<li><a href="#HAWQServerConfigurationParameters-gp_enable_agg_distinct">gp_enable_agg_distinct</a></li>
<li><a href="#HAWQServerConfigurationParameters-gp_enable_agg_distinct_pruning">gp_enable_agg_distinct_pruning</a></li>
<li><a href="#HAWQServerConfigurationParameters-gp_enable_direct_dispatch">gp_enable_direct_dispatch</a></li>
<li><a href="#HAWQServerConfigurationParameters-gp_enable_fallback_plan">gp_enable_fallback_plan</a></li>
<li><a href="#HAWQServerConfigurationParameters-gp_enable_fast_sri">gp_enable_fast_sri</a></li>
<li><a href="#HAWQServerConfigurationParameters-gp_enable_gpperfmon">gp_enable_gpperfmon</a></li>
<li><a href="#HAWQServerConfigurationParameters-gp_enable_groupext_distinct_gather">gp_enable_groupext_distinct_gather</a></li>
<li><a href="#HAWQServerConfigurationParameters-gp_enable_groupext_distinct_pruning">gp_enable_groupext_distinct_pruning</a></li>
<li><a href="#HAWQServerConfigurationParameters-gp_enable_multiphase_agg">gp_enable_multiphase_agg</a></li>
<li><a href="#HAWQServerConfigurationParameters-gp_enable_predicate_propagation">gp_enable_predicate_propagation</a></li>
<li><a href="#HAWQServerConfigurationParameters-gp_enable_preunique">gp_enable_preunique</a></li>
<li><a href="#HAWQServerConfigurationParameters-gp_enable_sequential_window_plans">gp_enable_sequential_window_plans</a></li>
<li><a href="#HAWQServerConfigurationParameters-gp_enable_sort_distinct">gp_enable_sort_distinct</a></li>
<li><a href="#HAWQServerConfigurationParameters-gp_enable_sort_limit">gp_enable_sort_limit</a></li>
<li><a href="#HAWQServerConfigurationParameters-gp_external_enable_exec">gp_external_enable_exec</a></li>
<li><a href="#HAWQServerConfigurationParameters-gp_external_grant_privileges">gp_external_grant_privileges</a></li>
<li><a href="#HAWQServerConfigurationParameters-gp_external_max_segs">gp_external_max_segs</a></li>
<li><a href="#HAWQServerConfigurationParameters-gp_filerep_tcp_keepalives_count">gp_filerep_tcp_keepalives_count</a></li>
<li><a href="#HAWQServerConfigurationParameters-gp_filerep_tcp_keepalives_idle">gp_filerep_tcp_keepalives_idle</a></li>
<li><a href="#HAWQServerConfigurationParameters-gp_filerep_tcp_keepalives_interval">gp_filerep_tcp_keepalives_interval</a></li>
<li><a href="#HAWQServerConfigurationParameters-gp_fts_probe_interval">gp_fts_probe_interval</a></li>
<li><a href="#HAWQServerConfigurationParameters-gp_fts_probe_threadcount">gp_fts_probe_threadcount</a></li>
<li><a href="#HAWQServerConfigurationParameters-gp_fts_probe_timeout">gp_fts_probe_timeout</a></li>
<li><a href="#HAWQServerConfigurationParameters-gp_gpperfmon_send_interval">gp_gpperfmon_send_interval</a></li>
<li><a href="#HAWQServerConfigurationParameters-gp_hashjoin_tuples_per_bucket">gp_hashjoin_tuples_per_bucket</a></li>
<li><a href="#HAWQServerConfigurationParameters-gp_interconnect_default_rtt">gp_interconnect_default_rtt</a></li>
<li><a href="#HAWQServerConfigurationParameters-gp_interconnect_fc_method">gp_interconnect_fc_method</a></li>
<li><a href="#HAWQServerConfigurationParameters-gp_interconnect_hash_multiplier">gp_interconnect_hash_multiplier</a></li>
<li><a href="#HAWQServerConfigurationParameters-gp_interconnect_min_rto">gp_interconnect_min_rto</a></li>
<li><a href="#HAWQServerConfigurationParameters-gp_interconnect_min_retries_before_timeout">gp_interconnect_min_retries_before_timeout</a></li>
<li><a href="#HAWQServerConfigurationParameters-gp_interconnect_queue_depth">gp_interconnect_queue_depth</a></li>
<li><a href="#HAWQServerConfigurationParameters-gp_interconnect_setup_timeout">gp_interconnect_setup_timeout</a></li>
<li><a href="#HAWQServerConfigurationParameters-gp_interconnect_send_queue_depth">gp_interconnect_send_queue_depth</a></li>
<li><a href="#HAWQServerConfigurationParameters-gp_interconnect_timer_period">gp_interconnect_timer_period</a></li>
<li><a href="#HAWQServerConfigurationParameters-gp_interconnect_timer_checking_period">gp_interconnect_timer_checking_period</a></li>
<li><a href="#HAWQServerConfigurationParameters-gp_interconnect_transmit_timeout">gp_interconnect_transmit_timeout</a></li>
<li><a href="#HAWQServerConfigurationParameters-gp_interconnect_type">gp_interconnect_type</a></li>
<li><a href="#HAWQServerConfigurationParameters-gp_log_format">gp_log_format</a></li>
<li><a href="#HAWQServerConfigurationParameters-gp_max_csv_line_length">gp_max_csv_line_length</a></li>
<li><a href="#HAWQServerConfigurationParameters-gp_max_databases">gp_max_databases</a></li>
<li><a href="#HAWQServerConfigurationParameters-gp_max_filespaces">gp_max_filespaces</a></li>
<li><a href="#HAWQServerConfigurationParameters-gp_max_local_distributed_cache">gp_max_local_distributed_cache</a></li>
<li><a href="#HAWQServerConfigurationParameters-gp_max_packet_size">gp_max_packet_size</a></li>
<li><a href="#HAWQServerConfigurationParameters-gp_max_tablespaces">gp_max_tablespaces</a></li>
<li><a href="#HAWQServerConfigurationParameters-gp_motion_cost_per_row">gp_motion_cost_per_row</a></li>
<li><a href="#HAWQServerConfigurationParameters-gp_num_contents_in_cluster">gp_num_contents_in_cluster</a></li>
<li><a href="#HAWQServerConfigurationParameters-gp_reject_percent_threshold">gp_reject_percent_threshold</a></li>
<li><a href="#HAWQServerConfigurationParameters-gp_reraise_signal">gp_reraise_signal</a></li>
<li><a href="#HAWQServerConfigurationParameters-gp_resqueue_memory_policy">gp_resqueue_memory_policy</a></li>
<li><a href="#HAWQServerConfigurationParameters-gp_resqueue_priority">gp_resqueue_priority</a></li>
<li><a href="#HAWQServerConfigurationParameters-gp_resequeue_priority_cpucores_per_segment">gp_resequeue_priority_cpucores_per_segment</a></li>
<li><a href="#HAWQServerConfigurationParameters-gp_resqueue_priority_sweeper_interval">gp_resqueue_priority_sweeper_interval</a></li>
<li><a href="#HAWQServerConfigurationParameters-gp_role">gp_role</a></li>
<li><a href="#HAWQServerConfigurationParameters-gp_safefswritesize">gp_safefswritesize</a></li>
<li><a href="#HAWQServerConfigurationParameters-gp_segment_connect_timeout">gp_segment_connect_timeout</a></li>
<li><a href="#HAWQServerConfigurationParameters-gp_segments_for_planner">gp_segments_for_planner</a></li>
<li><a href="#HAWQServerConfigurationParameters-gp_session_id">gp_session_id</a></li>
<li><a href="#HAWQServerConfigurationParameters-gp_set_proc_affinity">gp_set_proc_affinity</a></li>
<li><a href="#HAWQServerConfigurationParameters-gp_set_read_only">gp_set_read_only</a></li>
<li><a href="#HAWQServerConfigurationParameters-gp_snmp_community">gp_snmp_community</a></li>
<li><a href="#HAWQServerConfigurationParameters-gp_snmp_monitor_address">gp_snmp_monitor_address</a></li>
<li><a href="#HAWQServerConfigurationParameters-gp_snmp_use_inform_or_trap">gp_snmp_use_inform_or_trap</a></li>
<li><a href="#HAWQServerConfigurationParameters-gp_statistics_pullup_from_child_partition">gp_statistics_pullup_from_child_partition</a></li>
<li><a href="#HAWQServerConfigurationParameters-gp_statistics_use_fkeys">gp_statistics_use_fkeys</a></li>
<li><a href="#HAWQServerConfigurationParameters-gp_vmem_idle_resource_timeout">gp_vmem_idle_resource_timeout</a></li>
<li><a href="#HAWQServerConfigurationParameters-gp_vmem_protect_limit">gp_vmem_protect_limit</a></li>
<li><a href="#HAWQServerConfigurationParameters-gp_vmem_protect_segworker_cache_limit">gp_vmem_protect_segworker_cache_limit</a></li>
<li><a href="#HAWQServerConfigurationParameters-gp_workfile_checksumming">gp_workfile_checksumming</a></li>
<li><a href="#HAWQServerConfigurationParameters-gp_workfile_compress_algorithm">gp_workfile_compress_algorithm</a></li>
<li><a href="#HAWQServerConfigurationParameters-gp_workfile_limit_per_query">gp_workfile_limit_per_query</a></li>
<li><a href="#HAWQServerConfigurationParameters-gpperfmon_port"> gpperfmon_port</a></li>
<li><a href="#HAWQServerConfigurationParameters-pxf_enable_stat_collection">pxf_enable_stat_collection</a></li>
<li><a href="#HAWQServerConfigurationParameters-integer_datetimes">integer_datetimes</a></li>
<li><a href="#HAWQServerConfigurationParameters-IntervalStyle">IntervalStyle</a></li>
<li><a href="#HAWQServerConfigurationParameters-join_collapse_limit">join_collapse_limit</a></li>
<li><a href="#HAWQServerConfigurationParameters-krb_caseins_users">krb_caseins_users</a></li>
<li><a href="#HAWQServerConfigurationParameters-krb_server_keyfile">krb_server_keyfile</a></li>
<li><a href="#HAWQServerConfigurationParameters-krb_srvname">krb_srvname</a></li>
<li><a href="#HAWQServerConfigurationParameters-krb5_ccname">krb5_ccname</a></li>
<li><a href="#HAWQServerConfigurationParameters-lc_collate">lc_collate</a></li>
<li><a href="#HAWQServerConfigurationParameters-lc_ctype">lc_ctype</a></li>
<li><a href="#HAWQServerConfigurationParameters-lc_messages">lc_messages</a></li>
<li><a href="#HAWQServerConfigurationParameters-lc_monetary">lc_monetary</a></li>
<li><a href="#HAWQServerConfigurationParameters-lc_numeric">lc_numeric</a></li>
<li><a href="#HAWQServerConfigurationParameters-lc_time">lc_time</a></li>
<li><a href="#HAWQServerConfigurationParameters-listen_addresses">listen_addresses</a></li>
<li><a href="#HAWQServerConfigurationParameters-local_preload_libraries">local_preload_libraries</a></li>
<li><a href="#HAWQServerConfigurationParameters-log_autostats">log_autostats</a></li>
<li><a href="#HAWQServerConfigurationParameters-log_connections">log_connections</a></li>
<li><a href="#HAWQServerConfigurationParameters-log_disconnections">log_disconnections</a></li>
<li><a href="#HAWQServerConfigurationParameters-log_dispatch_stats">log_dispatch_stats</a></li>
<li><a href="#HAWQServerConfigurationParameters-log_duration">log_duration</a></li>
<li><a href="#HAWQServerConfigurationParameters-log_error_verbosity">log_error_verbosity</a></li>
<li><a href="#HAWQServerConfigurationParameters-log_executor_stats">log_executor_stats</a></li>
<li><a href="#HAWQServerConfigurationParameters-log_hostname">log_hostname</a></li>
<li><a href="#HAWQServerConfigurationParameters-log_min_duration_statement">log_min_duration_statement</a></li>
<li><a href="#HAWQServerConfigurationParameters-log_min_error_statement">log_min_error_statement</a></li>
<li><a href="#HAWQServerConfigurationParameters-log_min_messages">log_min_messages</a></li>
<li><a href="#HAWQServerConfigurationParameters-log_parser_stats">log_parser_stats</a></li>
<li><a href="#HAWQServerConfigurationParameters-log_planner_stats">log_planner_stats</a></li>
<li><a href="#HAWQServerConfigurationParameters-log_rotation_age">log_rotation_age</a></li>
<li><a href="#HAWQServerConfigurationParameters-log_rotation_size">log_rotation_size</a></li>
<li><a href="#HAWQServerConfigurationParameters-log_statement">log_statement</a></li>
<li><a href="#HAWQServerConfigurationParameters-log_statement_stats">log_statement_stats</a></li>
<li><a href="#HAWQServerConfigurationParameters-log_timezone">log_timezone</a></li>
<li><a href="#HAWQServerConfigurationParameters-log_truncate_on_rotation">log_truncate_on_rotation</a></li>
<li><a href="#HAWQServerConfigurationParameters-max_appendonly_tables">max_appendonly_tables</a></li>
<li><a href="#HAWQServerConfigurationParameters-max_connections">max_connections</a></li>
<li><a href="#HAWQServerConfigurationParameters-max_files_per_process">max_files_per_process</a></li>
<li><a href="#HAWQServerConfigurationParameters-max_fsm_pages">max_fsm_pages</a></li>
<li><a href="#HAWQServerConfigurationParameters-max_fsm_relations">max_fsm_relations</a></li>
<li><a href="#HAWQServerConfigurationParameters-max_function_args">max_function_args</a></li>
<li><a href="#HAWQServerConfigurationParameters-max_identifier_length">max_identifier_length</a></li>
<li><a href="#HAWQServerConfigurationParameters-max_locks_per_transaction">max_locks_per_transaction</a></li>
<li><a href="#HAWQServerConfigurationParameters-max_prepared_transactions">max_prepared_transactions</a></li>
<li><a href="#HAWQServerConfigurationParameters-max_resource_portals_per_transaction">max_resource_portals_per_transaction</a></li>
<li><a href="#HAWQServerConfigurationParameters-max_resource_queues">max_resource_queues</a></li>
<li><a href="#HAWQServerConfigurationParameters-max_stack_depth">max_stack_depth</a></li>
<li><a href="#HAWQServerConfigurationParameters-max_statement_mem">max_statement_mem</a></li>
<li><a href="#HAWQServerConfigurationParameters-optimizer_log">optimizer_log</a></li>
<li><a href="#HAWQServerConfigurationParameters-optimizer_minidump">optimizer_minidump</a></li>
<li><a href="#HAWQServerConfigurationParameters-password_encryption">password_encryption</a></li>
<li><a href="#HAWQServerConfigurationParameters-port">port</a></li>
<li><a href="#HAWQServerConfigurationParameters-random_page_cost">random_page_cost</a></li>
<li><a href="#HAWQServerConfigurationParameters-regex_flavor">regex_flavor</a></li>
<li><a href="#HAWQServerConfigurationParameters-resource_cleanup_gangs_on_wait">resource_cleanup_gangs_on_wait</a></li>
<li><a href="#HAWQServerConfigurationParameters-resource_select_only">resource_select_only</a></li>
<li><a href="#HAWQServerConfigurationParameters-search_path">search_path</a></li>
<li><a href="#HAWQServerConfigurationParameters-seq_page_cost">seq_page_cost</a></li>
<li><a href="#HAWQServerConfigurationParameters-server_encoding">server_encoding</a></li>
<li><a href="#HAWQServerConfigurationParameters-server_ticket_renew_interval">server_ticket_renew_interval</a></li>
<li><a href="#HAWQServerConfigurationParameters-server_version">server_version</a></li>
<li><a href="#HAWQServerConfigurationParameters-server_version_num">server_version_num</a></li>
<li><a href="#HAWQServerConfigurationParameters-shared_buffers">shared_buffers</a></li>
<li><a href="#HAWQServerConfigurationParameters-shared_preload_libraries">shared_preload_libraries</a></li>
<li><a href="#HAWQServerConfigurationParameters-ssl">ssl</a></li>
<li><a href="#HAWQServerConfigurationParameters-ssl_ciphers">ssl_ciphers</a></li>
<li><a href="#HAWQServerConfigurationParameters-standard_conforming_strings">standard_conforming_strings</a></li>
<li><a href="#HAWQServerConfigurationParameters-statement_mem">statement_mem</a></li>
<li><a href="#HAWQServerConfigurationParameters-statement_timeout">statement_timeout</a></li>
<li><a href="#HAWQServerConfigurationParameters-stats_queue_level">stats_queue_level</a></li>
<li><a href="#HAWQServerConfigurationParameters-superuser_reserved_connections">superuser_reserved_connections</a></li>
<li><a href="#HAWQServerConfigurationParameters-tcp_keepalives_count">tcp_keepalives_count</a></li>
<li><a href="#HAWQServerConfigurationParameters-tcp_keepalives_idle">tcp_keepalives_idle</a></li>
<li><a href="#HAWQServerConfigurationParameters-tcp_keepalives_interval">tcp_keepalives_interval</a></li>
<li><a href="#HAWQServerConfigurationParameters-temp_buffers">temp_buffers</a></li>
<li><a href="#HAWQServerConfigurationParameters-TimeZone">TimeZone</a></li>
<li><a href="#HAWQServerConfigurationParameters-timezone_abbreviations">timezone_abbreviations</a></li>
<li><a href="#HAWQServerConfigurationParameters-track_activities">track_activities</a></li>
<li><a href="#HAWQServerConfigurationParameters-track_counts">track_counts</a></li>
<li><a href="#HAWQServerConfigurationParameters-transaction_isolation">transaction_isolation</a></li>
<li><a href="#HAWQServerConfigurationParameters-transaction_read_only">transaction_read_only</a></li>
<li><a href="#HAWQServerConfigurationParameters-transform_null_equals">transform_null_equals</a></li>
<li><a href="#HAWQServerConfigurationParameters-unix_socket_directory">unix_socket_directory</a></li>
<li><a href="#HAWQServerConfigurationParameters-unix_socket_group">unix_socket_group</a></li>
<li><a href="#HAWQServerConfigurationParameters-unix_socket_permissions">unix_socket_permissions</a></li>
<li><a href="#HAWQServerConfigurationParameters-update_process_title">update_process_title</a></li>
<li><a href="#HAWQServerConfigurationParameters-vacuum_cost_delay">vacuum_cost_delay</a></li>
<li><a href="#HAWQServerConfigurationParameters-vacuum_cost_limit">vacuum_cost_limit</a></li>
<li><a href="#HAWQServerConfigurationParameters-vacuum_cost_page_dirty">vacuum_cost_page_dirty</a></li>
<li><a href="#HAWQServerConfigurationParameters-vacuum_cost_page_hit">vacuum_cost_page_hit</a></li>
<li><a href="#HAWQServerConfigurationParameters-vacuum_cost_page_miss">vacuum_cost_page_miss</a></li>
<li><a href="#HAWQServerConfigurationParameters-vacuum_freeze_min_age">vacuum_freeze_min_age</a></li>
</ul>
</li>
</ul>
</div></p><h2 id="HAWQServerConfigurationParameters-ParameterTypesandValues">Parameter Types and Values</h2><p align="LEFT">All parameter names are case-insensitive. Every parameter takes a value of one of four types: Boolean, integer, floating point , or string. Boolean values may be written as ON, OFF, TRUE, FALSE, YES, NO, 1, 0 (all case-insensitive).</p><p align="LEFT">Some settings specify a memory size or time value. Each of these has an implicit unit, which is either kilobytes, blocks (typically eight kilobytes), milliseconds, seconds, or minutes. Valid memory size units are <strong>kB </strong> <span style="font-size: small;"> </span>(kilobytes), <strong>MB </strong>(megabytes), and <strong>GB </strong> <span style="font-size: small;"> </span>(gigabytes). Valid time units are <strong>ms </strong> <span style="font-size: small;"> </span>(milliseconds), <strong>s </strong> <span style="font-size: small;"> </span>(seconds), <strong>min </strong> <span style="font-size: small;"> </span>(minutes), <strong>h </strong> <span style="font-size: small;"> </span>(hours), and <strong>d </strong>(days). Note that the multiplier for memory units is 1024, not 1000. A valid time expression contains a number and a unit. When specifying a memory or time unit using the SET command, enclose the value in quotes. For example:</p><div class="code panel pdl" style="border-width: 1px;"><div class="codeContent panelContent pdl">
<pre class="theme: Confluence; brush: sql; gutter: false" style="font-size:12px;">SET work_mem TO '200MB';</pre>
</div></div><p align="LEFT">Note: There is no space between the value and the unit names.</p><h2 id="HAWQServerConfigurationParameters-SettingParameters">Setting Parameters</h2><p align="LEFT">Many of the configuration parameters have limitations on who can change them and where or when they can be set. For example, to change certain parameters, you must be a HAWQ superuser. Other parameters require a restart of the system for the changes to take effect. A parameter that is classified as <em>session </em> <span style="font-size: medium;"> </span>can be set at the system level (in the postgresql.conf file), at the database-level (using CREATE DATABASE), at the role-level (using ALTER ROLE), or at the session-level (using SET). System parameters can only be set in the postgresql.conf file.</p><p align="LEFT">In HAWQ, the master and each segment instance has its own postgresql.conf file (located in their respective data directories). Some parameters are considered <em>local </em> <span style="font-size: medium;"> </span>parameters, meaning that each segment instance looks to its own postgresql.conf file to get the value of that parameter. You must set local parameters on every instance in the system (master and segments). Others parameters are considered <em>master </em> <span style="font-size: medium;"> </span>parameters. Master parameters need only be set at the master instance.</p><p><strong>Table: Settable Classifications</strong></p><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Set classification</th><th class="confluenceTh">Description</th></tr><tr><td class="confluenceTd">master or local</td><td class="confluenceTd"><p align="LEFT">A <em>master </em> <span style="font-size: xx-small;"> </span>parameter only needs to be set in the postgresql.conf file of the HAWQ master instance. The value for this parameter is then either passed to (or ignored by) the segments at run time.</p><p align="LEFT">A local parameter must be set in the postgresql.conf file of the master AND each segment instance. Each segment instance looks to its own configuration to get the value for the parameter. Local parameters always requires a system restart for changes to take effect.</p></td></tr><tr><td class="confluenceTd">session or system</td><td class="confluenceTd"><p align="LEFT">Session parameters can be changed on the fly within a database session, and can have a hierarchy of settings: at the system level (postgresql.conf), at the database level (ALTER DATABASE...SET), at the role level (ALTER ROLE...SET), or at the session level (SET). If the parameter is set at multiple levels, then the most granular setting takes precedence (for example, session overrides role, role overrides database, and database overrides system).</p><p>A <em>system </em> <span style="font-size: xx-small;"> </span>parameter can only be changed via the postgresql.conf file(s).</p><span style="font-size: xx-small;"> </span></td></tr><tr><td class="confluenceTd">restart or reload</td><td class="confluenceTd"><p align="LEFT">When changing parameter values in the postgrsql.conf file(s), some require a <em>restart </em> <span style="font-size: xx-small;"> </span>of HAWQ for the change to take effect. Other parameter values can be refreshed by just reloading the server configuration file (using gpstop -u), and do not require stopping the system.</p><span style="font-size: xx-small;"> </span></td></tr><tr><td class="confluenceTd">superuser</td><td class="confluenceTd"><p align="LEFT">These session parameters can only be set by a database superuser. Regular database users cannot set this parameter.</p></td></tr><tr><td class="confluenceTd" colspan="1">readonly</td><td class="confluenceTd" colspan="1">These parameters are not settable by database users or superusers. The current value of the parameter can be shown but not altered.</td></tr></tbody></table></div><h2 id="HAWQServerConfigurationParameters-ServerConfigurationParameters">Server Configuration Parameters</h2><h3 id="HAWQServerConfigurationParameters-add_missing_from">add_missing_from</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd"><p>Boolean</p><p><strong>Default</strong>: Off</p></td><td class="confluenceTd"><p align="LEFT">Automatically adds missing table references to FROM clauses.</p><p align="LEFT">Present for compatibility with releases of PostgreSQL prior to 8.1, where this behavior was allowed by default.</p></td><td class="confluenceTd"><p align="LEFT">master<br/>session<br/>reload</p></td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-application">application</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd"><p>String</p><p><strong>Default</strong>: On</p></td><td class="confluenceTd"><p align="LEFT">Sets the application name for a client session. For example, if connecting via psql, this will be set to psql.</p><p align="LEFT">Setting an application name allows it to be reported in log messages and statistics views.</p></td><td class="confluenceTd"><p align="LEFT">master <br/>session <br/>reload</p></td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-array_null">array_null</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd"><p>Boolean</p><p><strong>Default</strong>: On</p></td><td class="confluenceTd"><p align="LEFT">This controls whether the array input parser recognizes unquoted NULL as specifying a null array element.</p><p align="LEFT">By default, this is on, allowing array values containing null values to be entered.</p><p align="LEFT">HAWQ versions before 3.0 did not support null values in arrays, and therefore would treat NULL as specifying<br/> a normal array element with the string value ‘NULL’.</p></td><td class="confluenceTd"><p align="LEFT">master <br/>session <br/>reload</p></td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-authentication_timeout">authentication_timeout</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd"><p align="LEFT">Any valid time expression<br/>(number and unit)</p><p><strong>Default</strong>: 1 min</p></td><td class="confluenceTd"><p align="LEFT">Maximum time to complete client authentication. This prevents hung clients from occupying a connection indefinitely.</p></td><td class="confluenceTd">local<br/>system<br/>restart</td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-backslash_quote">backslash_quote</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd"><p align="LEFT">on (allow \'always)</p><p align="LEFT">off (reject always)</p><p align="LEFT">safe_encoding (allow only if client encoding does not allow ASCII \ within a multibyte character)</p></td><td class="confluenceTd"><p align="LEFT">This controls whether a quote mark can be represented by \' in a string literal.</p><p align="LEFT">The preferred, SQL-standard way to represent a quote mark is by doubling it ('') but PostgreSQL has historically also accepted \'. However, use of \' creates security risks because in some client character set encodings, there are multibyte characters in which the last byte is numerically equivalent to ASCII \.<br/> </p></td><td class="confluenceTd">master<br/>session<br/>reload</td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-block_size">block_size</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd"><p>number of bytes</p><p><strong>Default</strong>: 32768</p></td><td class="confluenceTd"> Reports the size of a disk block.</td><td class="confluenceTd"> read only</td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-bonjour_name">bonjour_name</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd"><p> string</p><p><strong>Default</strong>: unset</p></td><td class="confluenceTd">Specifies the Bonjour broadcast name. By default, the computer name is used, specified as an empty string. This option is ignored if the server was not compiled with Bonjour support.</td><td class="confluenceTd">master<br/>system<br/>restart </td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-check_functionbodies">check_function bodies</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"><p>boolean</p><p><strong>Default</strong>: On</p></td><td class="confluenceTd" colspan="1">When set to off, disables validation of the function body string during CREATE FUNCTION. Disabling validation is occasionally useful to avoid problems such as forward references when restoring function definitions from a dump.</td><td class="confluenceTd" colspan="1">master<br/>session<br/>reload </td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-client_encoding">client_encoding</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"><p>character set</p><p><strong>Default</strong>: UTF8</p></td><td class="confluenceTd" colspan="1">Sets the client-side encoding (character set). The default is to use the same as the database encoding.<br/>See Supported Character Sets in the PostgreSQL documentation.</td><td class="confluenceTd" colspan="1">master<br/>session<br/>reload </td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-client_min_messages">client_min_messages</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"><p>DEBUG5<br/>DEBUG4<br/>DEBUG3<br/>DEBUG2<br/>DEBUG1<br/>LOG<br/>NOTICE<br/>WARNING<br/>ERROR<br/>FATAL<br/>PANIC</p><p><strong>Default</strong>: Notice</p></td><td class="confluenceTd" colspan="1"><p>Controls which message levels are sent to the client. Each level includes all the levels that follow it.</p><p>The later the level, the fewer messages are sent.</p></td><td class="confluenceTd" colspan="1">master<br/>session<br/>reload </td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-cpu_operator_cost">cpu_operator_cost</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"><p> floating point</p><p><strong>Default</strong>: 0.0025</p></td><td class="confluenceTd" colspan="1">Sets the planner’s estimate of the cost of processing each operator in a WHERE clause. This is measured as a fraction of the cost of a sequential page fetch</td><td class="confluenceTd" colspan="1">master<br/>session<br/>reload </td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-cpu_tuple_cost">cpu_tuple_cost</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"><p>floating point </p><p><strong>Default</strong>: 0.01</p></td><td class="confluenceTd" colspan="1"><p><span>Sets the planner’s estimate of the cost of processing each row during a query. This is measured as a </span><span>fraction of the cost of a sequential page fetch</span></p></td><td class="confluenceTd" colspan="1"><span>master</span><br/><span>session</span><br/><span>reload</span></td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-cursor_tuple_fraction">cursor_tuple_fraction</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"><p>integer </p><p><strong>Default</strong>: 1</p></td><td class="confluenceTd" colspan="1">Tells the query planner how many rows are expected to be fetched in a cursor query, thereby allowing the planner to use this information to optimize the query plan. The default of 1 means all rows will be fetched.</td><td class="confluenceTd" colspan="1">master <br/>session <br/>reload </td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-cursor_tuple_fraction.1">cursor_tuple_fraction</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"><p>comma-separated list of classnames </p><p><strong>Default</strong>: unset</p></td><td class="confluenceTd" colspan="1">Specifies one or several class names to be used for custom variables. A custom variable is a variable not normally known to the server but used by some add-on module. Such variables must have names consisting of a class name, a dot, and a variable name.</td><td class="confluenceTd" colspan="1">local<br/>system<br/>restart </td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-DataStyle">DataStyle</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"><p><format>,<date style></p><p>where</p><p><format> is SO, Postgres, <br/>SQL, or German</p><p>and</p><p><date style><br/> is DMY, MDY, or YMD.</p><p><strong>Default</strong>: ISO, MDY</p></td><td class="confluenceTd" colspan="1">Sets the display format for date and time values, as well as the rules for interpreting ambiguous date input values. This variable contains two independent components: the output format specification and the input/output specification for year/month/day ordering.</td><td class="confluenceTd" colspan="1">master<br/>session<br/>reload </td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-db_user_namespace">db_user_namespace</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"><p>Boolean</p><p><strong>Default</strong>: Off</p> </td><td class="confluenceTd" colspan="1">This enables per-database user names. If on, you should create users as username@dbname. To create ordinary global users, simply append @ when specifying the user name in the client. </td><td class="confluenceTd" colspan="1">local <br/>system <br/>reload </td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-deadlock_timeout">deadlock_timeout</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"><p>Any valid time expression (number and unit)</p><p><strong>Default</strong>: 1s</p> </td><td class="confluenceTd" colspan="1">The time to wait on a lock before checking to see if there is a deadlock condition. On a heavily loaded server you might want to raise this value. Ideally the setting should exceed your typical transaction time, so as to improve the odds that a lock will be released before the waiter decides to check for deadlock </td><td class="confluenceTd" colspan="1">local <br/>system <br/>restart </td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-debug_assertions">debug_assertions</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"><p>Boolean</p><p><strong>Default</strong>: Off</p><p> </p></td><td class="confluenceTd" colspan="1">Turns on various assertion checks </td><td class="confluenceTd" colspan="1">local <br/>system <br/>restart </td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-debug_pretty_print">debug_pretty_print</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"><p> Boolean</p><p><strong>Default</strong>: Off</p></td><td class="confluenceTd" colspan="1"><p>Indents debug output to produce a more readable but much longer output format.</p><p>client_min_messages or log_min_messages must be DEBUG1 or lower.</p></td><td class="confluenceTd" colspan="1"> master<br/>session<br/>eload</td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-debug_print_parse">debug_print_parse</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"><p>Boolean </p><p><strong>Default</strong>: Off</p></td><td class="confluenceTd" colspan="1">For each executed query, prints the resulting parse tree. client_min_messages or log_min_messages must be DEBUG1 or lower.</td><td class="confluenceTd" colspan="1"> master<br/>session<br/>reload</td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-debug_print_plan">debug_print_plan</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"><p>Boolean</p><p><strong>Default</strong>: Off</p></td><td class="confluenceTd" colspan="1">For each executed query, prints the HAWQ parallel query execution plan. client_min_messages or log_min_messages must be DEBUG1 or lower.</td><td class="confluenceTd" colspan="1">master<br/>session<br/>reload </td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-debug_print_prelim_plan">debug_print_prelim_plan</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"><p>Boolean</p><p><strong>Default</strong>: Off</p></td><td class="confluenceTd" colspan="1">For each executed query, prints the preliminary query plan. client_min_messages or log_min_messages must be DEBUG1 or lower.</td><td class="confluenceTd" colspan="1">master<br/>session<br/>reload</td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-gp_autostats_mode">gp_autostats_mode</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"><p>none</p><p>on_change</p><p>on_no_stats</p><p><strong>Default</strong>: on_no_stats</p></td><td class="confluenceTd" colspan="1"><p align="LEFT">Specifies the mode for triggering automatic statistics collection with ANALYZE . The on_no_stats option triggers statistics collection for CREATE TABLE AS SELECT, INSERT, or COPY operations on any table that has no existing statistics.</p><p align="LEFT">The on_change option triggers statistics collection only when the number of rows affected meets or exceeds the threshold defined by gp_autostats_on_change_threshold. Operations that can trigger automatic statistics collection with on_change are:</p><p align="LEFT">CREATE TABLE AS SELECT<br/>UPDATE<br/>DELETE<br/>INSERT<br/>COPY</p><p align="LEFT">Default is on_no_stats.</p><span style="font-size: xx-small;"> </span> </td><td class="confluenceTd" colspan="1">master<p align="LEFT">session<br/>reload</p></td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-gp_autostats_on_change_threshold">gp_autostats_on_change_threshold</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"><p>integer</p><p><strong>Default</strong>: 2147483647</p></td><td class="confluenceTd" colspan="1"><p>Specifies the threshold for automatic statistics collection when gp_autostats_mode is set to on_change.</p><p>When a triggering table operation affects a number of rows exceeding this threshold, ANALYZE is added and statistics are collected for the table.</p></td><td class="confluenceTd" colspan="1"><p align="LEFT">master<br/>session<br/>reload</p> </td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-gp_cached_segworkers_threshold">gp_cached_segworkers_threshold</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"><p>integer > 0</p><p><strong>Default</strong>: 5</p><p> </p></td><td class="confluenceTd" colspan="1"><p align="LEFT">When a user starts a session with HAWQ and issues a query, the system creates groups or ‘gangs’ of worker processes on each segment to do the work. After the work is done, the segment worker processes are destroyed except for a cached number which is set by this parameter. A lower setting conserves system resources on the segment hosts, but a higher setting may improve performance for power-users that want to issue many complex queries in a row.</p> </td><td class="confluenceTd" colspan="1">master <br/>session<br/>reload </td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-gp_command_count">gp_command_count</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"><p> integer > 0 </p><p><strong>Default</strong>: 1</p></td><td class="confluenceTd" colspan="1">Shows how many commands the master has received from the client. Note that a single SQLcommand might actually involve more than one command internally, so the counter may increment by more than one for a single query. This counter also is shared by all of the segment processes working on the command.</td><td class="confluenceTd" colspan="1">read-only </td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-gp_connectemc_mode">gp_connectemc_mode</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"><p align="LEFT">on, off, local, remote</p><p><strong>Default</strong>: On</p> </td><td class="confluenceTd" colspan="1"><p>Controls the ConnectEMC event logging and dial-home capabilities of HAWQ Performance Monitor on the EMC Greenplum Data Computing Appliance (DCA). ConnectEMC must be installed in order to generate events. Allowed values are:</p><ul><li>on (the default) - log events to the gpperfmon database and send dial-home notifications to EMC Support</li><li>off - turns off ConnectEMC event logging and dial-home capabilities local - log events to the gpperfmon database only</li><li>remote - sends dial-home notifications to EMC Support (does not log events to the gpperfmon database).<span style="font-size: xx-small;"> </span></li></ul></td><td class="confluenceTd" colspan="1">master<br/>system<br/>restart<br/>superuser </td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-gp_connections_per_thread">gp_connections_per_thread</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"><p>integer </p><p><strong>Default</strong>: 64</p></td><td class="confluenceTd" colspan="1"><p align="LEFT">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.</p></td><td class="confluenceTd" colspan="1">master<br/>session <br/>reload</td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-gp_content">gp_content</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1">integer </td><td class="confluenceTd" colspan="1">The local content id of a segment.</td><td class="confluenceTd" colspan="1">read only </td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-gp_dbid">gp_dbid </h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1">integer </td><td class="confluenceTd" colspan="1">The local content dbid of a segment. </td><td class="confluenceTd" colspan="1">read only </td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-gp_debug_linger">gp_debug_linger</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1">Any valid time expression<p align="LEFT">(number and unit)</p><p><strong>Default</strong>: 0</p></td><td class="confluenceTd" colspan="1">Number of seconds for a HAWQ process to linger after a fatal internal error.</td><td class="confluenceTd" colspan="1">master<br/>session <br/>reload</td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-gp_dynamic_partition_pruning">gp_dynamic_partition_pruning</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"><p>on/off </p><p><strong>Default</strong>: on</p></td><td class="confluenceTd" colspan="1">Enables plans that can dynamically eliminate the scanning of partitions.</td><td class="confluenceTd" colspan="1">master<br/>session <br/>reload</td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-gp_email_from">gp_email_from</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1">string</td><td class="confluenceTd" colspan="1"><p align="LEFT">The email address used to send email alerts, in the format of:</p><p align="LEFT">'<em>username</em> <span style="font-size: xx-small;"> </span>@<em>domain.com</em> <span style="font-size: xx-small;"> </span>'</p><p align="LEFT">or</p><p>'<em>Name </em> <span style="font-size: xx-small;"> </span><<em>username</em> <span style="font-size: xx-small;"> </span>@<em>domain.com</em> <span style="font-size: xx-small;"> </span>>'</p><span style="font-size: xx-small;"> </span> </td><td class="confluenceTd" colspan="1"><p align="LEFT">master<br/>system<br/>restart</p> </td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-gp_email_smtp_password">gp_email_smtp_password</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1">string</td><td class="confluenceTd" colspan="1">The password/passphrase used to authenticate with the SMTP server.</td><td class="confluenceTd" colspan="1">master <br/>system <br/>restart</td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-gp_email_smtp_server">gp_email_smtp_server</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1">string</td><td class="confluenceTd" colspan="1"><p align="LEFT">The fully qualified domain name or IP address and port of the SMTP server to use to send the email alerts. Must be in the format of: smtp_servername.domain.com:port</p> </td><td class="confluenceTd" colspan="1">master <br/>system<br/>restart </td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-gp_email_smtp_userid">gp_email_smtp_userid</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"><p>string</p> </td><td class="confluenceTd" colspan="1"><p align="LEFT">The user id used to authenticate with the SMTP server.</p> </td><td class="confluenceTd" colspan="1">master <br/>system<br/>restart </td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-gp_email_to">gp_email_to</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1">string</td><td class="confluenceTd" colspan="1"><p align="LEFT">A semi-colon (;) separated list of email addresses to receive email alert messages to in the format of:</p><p align="LEFT">'<em>username</em> <span style="font-size: xx-small;"> </span>@<em>domain.com</em> <span style="font-size: xx-small;"> </span>'</p><p align="LEFT">or</p><p align="LEFT">'<em>Name </em> <span style="font-size: xx-small;"> </span><<em>username</em> <span style="font-size: xx-small;"> </span>@<em>domain.com</em> <span style="font-size: xx-small;"> </span>>'</p><p align="LEFT">If this parameter is not set, then email alerts are disabled.</p></td><td class="confluenceTd" colspan="1">master <br/>system<br/>restart </td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-gp_enable_adaptive_nestloop">gp_enable_adaptive_nestloop</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"><p>Boolean</p><p><strong>Default</strong>: On</p></td><td class="confluenceTd" colspan="1"><p align="LEFT">Enables the query planner to use a new type of join node called “Adaptive Nestloop” at query execution time. This causes the planner to favor a hash-join over a nested-loop join if the number of rows on the outer side of the join exceeds a precalculated threshold.</p></td><td class="confluenceTd" colspan="1">master <br/>session <br/>reload</td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-gp_enable_agg_distinct">gp_enable_agg_distinct</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"><p>Boolean</p><p><strong>Default</strong>: On</p></td><td class="confluenceTd" colspan="1">Enables or disables two-phase aggregation to compute a single distinct-qualified aggregate. This applies only to subqueries that include a single distinct-qualified aggregate function.</td><td class="confluenceTd" colspan="1">master <br/>system <br/>restart </td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-gp_enable_agg_distinct_pruning">gp_enable_agg_distinct_pruning</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"><p>Boolean</p><p><strong>Default</strong>: On</p></td><td class="confluenceTd" colspan="1">Enables or disables three-phase aggregation and join to compute distinct-qualified aggregates. This applies only to subqueries that include one or more distinct-qualified <br/>aggregate functions.</td><td class="confluenceTd" colspan="1">master <br/>session <br/>reload</td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-gp_enable_direct_dispatch">gp_enable_direct_dispatch</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"><p>Boolean</p><p><strong>Default</strong>: On</p></td><td class="confluenceTd" colspan="1">Enables or disables the dispatching of targeted query plans for queries that access data on a single segment. When on, queries that target rows on a single segment will only have their query plan dispatched to that segment (rather than to all segments). This significantly reduces the response time of qualifying queries as there is no interconnect setup involved. Direct dispatch does require more CPU utilization on the master.</td><td class="confluenceTd" colspan="1">master <br/>system <br/>restart </td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-gp_enable_fallback_plan">gp_enable_fallback_plan</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"><p>Boolean</p><p><strong>Default</strong>: On</p></td><td class="confluenceTd" colspan="1">Allows use of disabled plan types when a query would not be feasible without them.</td><td class="confluenceTd" colspan="1">master <br/>session <br/>reload</td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-gp_enable_fast_sri">gp_enable_fast_sri</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"><p>Boolean</p><p><strong>Default</strong>: On</p></td><td class="confluenceTd" colspan="1"><p align="LEFT">When set to on, the query planner plans single row inserts so that they are sent directly to the correct segment instance (no motion operation required). This significantly improves performance of single-row-insert statements.</p></td><td class="confluenceTd" colspan="1">master <br/>session reload </td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-gp_enable_gpperfmon">gp_enable_gpperfmon</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"><p>Boolean</p><p><strong>Default</strong>: On</p></td><td class="confluenceTd" colspan="1">Enables or disables the data collection agents of HAWQ Performance Monitor.</td><td class="confluenceTd" colspan="1"><p align="LEFT">local<br/>system<br/>restart</p> </td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-gp_enable_groupext_distinct_gather">gp_enable_groupext_distinct_gather</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"><p>Boolean</p><p><strong>Default</strong>: On</p></td><td class="confluenceTd" colspan="1"><p align="LEFT">Enables or disables gathering data to a single node to compute distinct-qualified aggregates on grouping extension queries. When this parameter and gp_enable_groupext_distinct_pruning are both enabled, the planner uses the cheaper plan. </p></td><td class="confluenceTd" colspan="1">master <br/>session <br/>reload</td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-gp_enable_groupext_distinct_pruning">gp_enable_groupext_distinct_pruning</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"><p>Boolean</p><p><strong>Default</strong>: On</p></td><td class="confluenceTd" colspan="1">Enables or disables three-phase aggregation and join to compute distinct-qualified aggregates on grouping extension queries. Usually, enabling this parameter <br/>generates a cheaper query plan that the planner will use in preference to existing plan.</td><td class="confluenceTd" colspan="1">master <br/>session <br/>reload </td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-gp_enable_multiphase_agg">gp_enable_multiphase_agg</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"><p>Boolean</p><p><strong>Default</strong>: On</p></td><td class="confluenceTd" colspan="1">Enables or disables the query planner’s use of two or three-stage parallel aggregation plans. This approach applies to any subquery with aggregation. If gp_enable_multiphase_agg is off, then gp_enable_agg_distinct and gp_enable_agg_distinct_pruning are disabled.</td><td class="confluenceTd" colspan="1">master <br/>session <br/>reload </td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-gp_enable_predicate_propagation">gp_enable_predicate_propagation</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"><p>Boolean</p><p><strong>Default</strong>: On</p> </td><td class="confluenceTd" colspan="1">When enabled, the query planner applies query predicates to both table expressions in cases where the tables are joined on their distribution key column(s). Filtering both <br/>tables prior to doing the join (when possible) is more efficient.</td><td class="confluenceTd" colspan="1">master <br/>session <br/>reload </td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-gp_enable_preunique">gp_enable_preunique</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"><p>Boolean</p><p><strong>Default</strong>: On</p></td><td class="confluenceTd" colspan="1"><p align="LEFT">Enables two-phase duplicate removal for SELECT DISTINCT queries (not SELECT COUNT (DISTINCT)). When enabled, it adds an extra SORT DISTINCT set of plan nodes before motioning. In cases where the distinct operation greatly reduces the number of rows, this extra SORT DISTINCT is much cheaper than the cost of sending the rows across the Interconnect.</p></td><td class="confluenceTd" colspan="1"><p>master<br/>session <br/>reload</p></td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-gp_enable_sequential_window_plans">gp_enable_sequential_window_plans</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"><p>Boolean</p><p><strong>Default</strong>: On</p></td><td class="confluenceTd" colspan="1"><p align="LEFT">If on, enables non-parallel (sequential) query plans for queries containing window function calls. If off, evaluates compatible window functions in parallel and rejoins the results. This is an experimental parameter.</p> </td><td class="confluenceTd" colspan="1">master <br/>session <br/>reload</td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-gp_enable_sort_distinct">gp_enable_sort_distinct</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"><p>Boolean</p><p><strong>Default</strong>: On</p></td><td class="confluenceTd" colspan="1">Enable duplicates to be removed while sorting.</td><td class="confluenceTd" colspan="1">master<br/>session <br/>reload</td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-gp_enable_sort_limit">gp_enable_sort_limit</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"><p> Boolean </p><p><strong>Default</strong>: On</p></td><td class="confluenceTd" colspan="1">Enable LIMIT operation to be performed while sorting. Sorts more efficiently when the plan requires the first <em>limit_number </em> <span style="font-size: xx-small;"> </span>of rows at most.</td><td class="confluenceTd" colspan="1">master<p align="LEFT">session<br/>reload</p></td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-gp_external_enable_exec">gp_external_enable_exec</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"><p>Boolean</p><p><strong>Default</strong>: On</p></td><td class="confluenceTd" colspan="1">Enables or disables the use of external tables that execute OS commands or scripts on the segment hosts (CREATE EXTERNAL TABLE EXECUTE syntax). Must be enabled if using the Performance Monitor or MapReduce features.</td><td class="confluenceTd" colspan="1">master<p align="LEFT">session<br/>reload</p></td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-gp_external_grant_privileges">gp_external_grant_privileges</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"><p>Boolean</p><p><strong>Default</strong>: On</p></td><td class="confluenceTd" colspan="1"><p align="LEFT">In releases prior to 4.0, enables or disables non-superusers to issue a CREATE EXTERNAL [WEB] TABLE command in cases where the LOCATION clause specifies http or gpfdist. In releases after 4.0, the ability to create an external table can be granted to a role using CREATE ROLE or ALTER ROLE.</p></td><td class="confluenceTd" colspan="1">master<p align="LEFT">session<br/>restart</p><p> </p></td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-gp_external_max_segs">gp_external_max_segs</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"><p>integer </p><p><strong>Default</strong>: 64</p></td><td class="confluenceTd" colspan="1"><p>Sets the number of segments that will scan external table data during an external table operation, the purpose being not to overload the system with scanning data and take away resources from other concurrent operations. This only applies to external tables that use the gpfdist:// protocol to access external table data.</p></td><td class="confluenceTd" colspan="1">master<p align="LEFT">session<br/>restart</p></td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-gp_filerep_tcp_keepalives_count">gp_filerep_tcp_keepalives_count</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"><p>number of lost keepalives</p><p><strong>Default</strong>: 2</p></td><td class="confluenceTd" colspan="1">How many keepalives may be lost before the connection is considered dead. A value of 0 uses the system default. If TCP_KEEPCNT is not supported, this parameter must be 0.<p align="LEFT">Use this parameter for all connections that are between a primary and mirror segment. Use tcp_keepalives_count for settings that are not between a primary and mirror segment.</p></td><td class="confluenceTd" colspan="1">master<br/>session<br/>restart</td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-gp_filerep_tcp_keepalives_idle">gp_filerep_tcp_keepalives_idle</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"><p>number of seconds</p><p><strong>Default</strong>: 1 min</p></td><td class="confluenceTd" colspan="1">Number of seconds between sending keepalives on an otherwise idle connection. A value of 0 uses the system default. If TCP_KEEPIDLE is not supported, this parameter must be 0. Use this parameter for all connections that are between a primary and mirror segment. Use tcp_keepalives_idle for settings that are not between a primary and mirror segment.</td><td class="confluenceTd" colspan="1">local<br/>system<br/>restart</td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-gp_filerep_tcp_keepalives_interval">gp_filerep_tcp_keepalives_interval</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"><p align="LEFT">number of seconds</p><p><strong>Default</strong>: 30 seconds</p></td><td class="confluenceTd" colspan="1"><p align="LEFT">How many seconds to wait for a response to a keepalive before retransmitting. A value of 0 uses the system default. If TCP_KEEPINTVL is not supported, this parameter must be 0.</p><p align="LEFT">Use this parameter for all connections that are between a primary and mirror segment.</p><p align="LEFT">Use tcp_keepalives_interval for settings that are not between a primary and mirror segment.</p></td><td class="confluenceTd" colspan="1">local <br/>system <br/>restart</td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-gp_fts_probe_interval">gp_fts_probe_interval</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"><p align="LEFT">10 seconds or greater</p><p><strong>Default</strong>: 1 min</p> </td><td class="confluenceTd" colspan="1">Specifies the polling interval for the fault detection process (ftsprobe). The ftsprobe <br/>process will take approximately this amount of time to detect a segment failure.</td><td class="confluenceTd" colspan="1">master <br/>session restart </td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-gp_fts_probe_threadcount">gp_fts_probe_threadcount</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"><p>1 - 128</p><p><strong>Default</strong>: 5</p></td><td class="confluenceTd" colspan="1">Specifies the number of ftsprobe threads to create. This parameter should be set to a value equal to or greater than the number of segments per host.</td><td class="confluenceTd" colspan="1">master session <br/>restart </td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-gp_fts_probe_timeout">gp_fts_probe_timeout</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"><p>10 secs or greater</p><p><strong>Default</strong>: 10 secs</p></td><td class="confluenceTd" colspan="1"><p align="LEFT">Specifies the allowed timeout for the fault detection process (ftsprobe) to establish a connection to a segment before declaring it down.</p> </td><td class="confluenceTd" colspan="1">master <br/>session <br/>restart </td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-gp_gpperfmon_send_interval">gp_gpperfmon_send_interval</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1">Any valid time expression<p align="LEFT">(number and unit)</p><p><strong>Default</strong>: 10 min</p></td><td class="confluenceTd" colspan="1">Sets the frequency that the HAWQ server processes send query execution updates to the Performance Monitor agent processes. Query operations (iterators) executed during this interval are sent through UDP to the segment monitor agents. If you find that an excessive number of UDP packets are dropped during long-running, complex <br/>queries, you may consider increasing this value.</td><td class="confluenceTd" colspan="1">master<p align="LEFT">system<br/>restart</p></td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-gp_hashjoin_tuples_per_bucket">gp_hashjoin_tuples_per_bucket</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"><p>integer</p><p><strong>Default</strong>: 5</p></td><td class="confluenceTd" colspan="1">Sets the target density of the hash table used by HashJoin operations. A smaller value will tend to produce larger hash tables, which can increase join performance.</td><td class="confluenceTd" colspan="1">master<p align="LEFT">session<br/>reload</p></td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-gp_interconnect_default_rtt">gp_interconnect_default_rtt</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"><p>1-1000ms</p><p><strong>Default</strong>: 20ms</p> </td><td class="confluenceTd" colspan="1"><p align="LEFT">Sets the default rtt (in ms) for UDP interconnect.</p> </td><td class="confluenceTd" colspan="1">master<p align="LEFT">session <br/>reload</p> </td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-gp_interconnect_fc_method">gp_interconnect_fc_method</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"><p>“capacity” or “loss”</p><p><strong>Default</strong>: "loss"</p></td><td class="confluenceTd" colspan="1"><p>Sets the flow control method used for UDP interconnect. Valid values are "capacity" and "loss". For “capacity” based flow control, senders do not send packets when receivers <br/>do not have capacity. “Loss” based flow control is based on “capacity” based flow control, <br/>and it also tunes sending speed according to packet losses.</p></td><td class="confluenceTd" colspan="1">master<p align="LEFT">session<br/>reload</p> </td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-gp_interconnect_hash_multiplier">gp_interconnect_hash_multiplier</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"><p>2-25</p><p><strong>Default</strong>: 2</p></td><td class="confluenceTd" colspan="1">Sets the size of the hash table used by the UDP interconnect to track connections. This number is multiplied by the number of segments to determine the number of buckets in the hash table. Increasing the value may increase interconnect performance for complex multi-slice queries (while consuming slightly more memory on the segment hosts).</td><td class="confluenceTd" colspan="1">master<p align="LEFT">session <br/>reload</p></td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-gp_interconnect_min_rto">gp_interconnect_min_rto</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"><p>1-1000ms</p><p><strong>Default</strong>: 20ms</p></td><td class="confluenceTd" colspan="1">Sets the min rto (in ms) for UDP interconnect.</td><td class="confluenceTd" colspan="1">master<p align="LEFT">session <br/>reload</p></td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-gp_interconnect_min_retries_before_timeout">gp_interconnect_min_retries_before_timeout</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"><p> 1-4096</p><p><strong>Default</strong>: 100</p></td><td class="confluenceTd" colspan="1">Sets the min retries before reporting a transmit timeout in the interconnect<p> </p></td><td class="confluenceTd" colspan="1">master<p align="LEFT">session <br/>reload</p></td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-gp_interconnect_queue_depth">gp_interconnect_queue_depth</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"><p> 1-2048</p><p><strong>Default</strong>: 4</p></td><td class="confluenceTd" colspan="1"><p align="LEFT">Sets the amount of data per-peer to be queued by the UDP interconnect on receivers (when data is received but no space is available to receive it the data will be dropped, and the transmitter will need to resend it). Increasing the depth from its default value will cause the system to use more memory; but may increase performance. It is reasonable for this to be set between 1 and 10. Queries with data skew potentially perform better when this is increased. Increasing this may radically increase the amount of memory used by the system.</p></td><td class="confluenceTd" colspan="1">master<p align="LEFT">session <br/>reload</p></td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-gp_interconnect_setup_timeout">gp_interconnect_setup_timeout</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1">Any valid time expression<p align="LEFT">(number and unit)</p><p><strong>Default</strong>: 5 min</p></td><td class="confluenceTd" colspan="1">Time to wait for the Interconnect to complete setup before it times out.</td><td class="confluenceTd" colspan="1">master<p align="LEFT">session <br/>reload</p></td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-gp_interconnect_send_queue_depth">gp_interconnect_send_queue_depth</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"><p>1-4096</p><p><strong>Default</strong>: 2</p></td><td class="confluenceTd" colspan="1">Used to specify the average size of a send queue. The buffer pool size for each send process can be calculated by using gp_interconnect_snd_queue_depth * number of processes in the downstream gang.</td><td class="confluenceTd" colspan="1">master<p align="LEFT">session <br/>reload</p> </td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-gp_interconnect_timer_period">gp_interconnect_timer_period</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"><p>1-100ms</p><p><strong>Default</strong>: 5ms</p></td><td class="confluenceTd" colspan="1">Sets the timer period (in ms) for UDP interconnect. Default value is 5ms</td><td class="confluenceTd" colspan="1">master<br/>session<br/>reload</td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-gp_interconnect_timer_checking_period">gp_interconnect_timer_checking_period</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"><p>1-100ms</p><p><strong>Default</strong>: 20ms</p> </td><td class="confluenceTd" colspan="1">Sets the timer checking period (in ms) for UDP interconnect</td><td class="confluenceTd" colspan="1">master <br/>session <br/>reload </td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-gp_interconnect_transmit_timeout">gp_interconnect_transmit_timeout</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"><p>1-7200s</p><p><strong>Default</strong>: 3600</p> </td><td class="confluenceTd" colspan="1">Timeout (in seconds) on interconnect to transmit a packet.</td><td class="confluenceTd" colspan="1">master <br/>session <br/>reload </td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-gp_interconnect_type">gp_interconnect_type</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"><p align="LEFT">TCP<br/>UDP</p><p><strong>Default</strong>: UDP</p></td><td class="confluenceTd" colspan="1">Sets the networking protocol used for Interconnect traffic. With the TCP protocol, HAWQ has an upper limit of 1000 segment instances - less than that if the query workload involves complex, multi-slice queries. UDP allows for greater interconnect scalability. Note that the HAWQ software does the additional packet verification and checking not performed by UDP, so reliability and performance is equivalent to TCP.</td><td class="confluenceTd" colspan="1"> </td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-gp_log_format">gp_log_format</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"><p align="LEFT">csv<br/>text</p><p><strong>Default</strong>: csv</p> </td><td class="confluenceTd" colspan="1"><p>Specifies the format of the server log files. If using <em>gp_toolkit </em> <span style="font-size: xx-small;"> </span>administrative schema, the log files must be in csv format.</p></td><td class="confluenceTd" colspan="1"><p align="LEFT">local<br/>system<br/>restart </p></td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-gp_max_csv_line_length">gp_max_csv_line_length</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"><p>number of bytes</p><p><strong>Default</strong>: 1048576</p></td><td class="confluenceTd" colspan="1">The maximum length of a line in a CSV formatted file that will be imported into the system. The default is 1MB (1048576 bytes). Maximum allowed is 4MB (4194184 bytes). <br/>The default may need to be increased if using the <em>gp_toolkit </em>administrative schema to read HAWQ log files.</td><td class="confluenceTd" colspan="1">local<p align="LEFT">system<br/>restart</p></td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-gp_max_databases">gp_max_databases</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"><p>1-64</p><p><strong>Default</strong>: 16</p></td><td class="confluenceTd" colspan="1">The maximum number of databases allowed in a HAWQ system.</td><td class="confluenceTd" colspan="1"><p align="LEFT">master<br/>system<br/>restart </p></td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-gp_max_filespaces">gp_max_filespaces</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"><p>1-32 </p><p><strong>Default</strong>: 8</p></td><td class="confluenceTd" colspan="1">The maximum number of filespaces allowed in a HAWQ system.</td><td class="confluenceTd" colspan="1"><p align="LEFT">master<br/>system<br/>restart</p></td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-gp_max_local_distributed_cache">gp_max_local_distributed_cache</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"><p>Integer</p><p><strong>Default</strong>: 1024</p></td><td class="confluenceTd" colspan="1">Sets the number of local to distributed transactions to cache. Higher settings may improve performance.</td><td class="confluenceTd" colspan="1">master<p align="LEFT">system<br/>restart</p></td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-gp_max_packet_size">gp_max_packet_size</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"><p>512-65536</p><p><strong>Default</strong>: 8192</p></td><td class="confluenceTd" colspan="1">Sets the size (in bytes) of messages sent by the UDP interconnect, and sets the tuple-serialization chunk size for both the UDP and TCP interconnect.</td><td class="confluenceTd" colspan="1">master<p align="LEFT">system<br/>restart</p></td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-gp_max_tablespaces">gp_max_tablespaces</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"><p>1-64</p><p><strong>Default</strong>: 16</p></td><td class="confluenceTd" colspan="1">The maximum number of tablespaces allowed in a HAWQ system.</td><td class="confluenceTd" colspan="1">master<p align="LEFT">system<br/>restart</p></td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-gp_motion_cost_per_row">gp_motion_cost_per_row</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"><p>floating point</p><p><strong>Default</strong>: 0</p></td><td class="confluenceTd" colspan="1">Sets the query planner cost estimate for a Motion operator to transfer a row from one segment to another, measured as a fraction of the cost of a sequential page fetch. If 0, then the value used is twotimes the value of <em>cpu_tuple_cost</em> <span style="font-size: xx-small;"> </span>.<span style="font-size: xx-small;"> </span></td><td class="confluenceTd" colspan="1">master<p align="LEFT">session<br/>reload</p></td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-gp_num_contents_in_cluster">gp_num_contents_in_cluster</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"> </td><td class="confluenceTd" colspan="1"><p align="LEFT">The number of primary segments in the HAWQ system</p> </td><td class="confluenceTd" colspan="1">read only</td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-gp_reject_percent_threshold">gp_reject_percent_threshold</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"><p>1-n</p><p><strong>Default</strong>: 300</p></td><td class="confluenceTd" colspan="1">For single row error handling on COPY and external table SELECTs, sets the number of rows processed before SEGMENT REJECT LIMIT <em>n </em> <span style="font-size: xx-small;"> </span>PERCENT starts calculating.</td><td class="confluenceTd" colspan="1">master<p align="LEFT">session<br/>reload</p></td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-gp_reraise_signal">gp_reraise_signal</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"><p>Boolean</p><p><strong>Default</strong>: on</p></td><td class="confluenceTd" colspan="1">If enabled, will attempt to dump core if a fatal server error occurs.</td><td class="confluenceTd" colspan="1">master<p align="LEFT">session<br/>reload</p></td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-gp_resqueue_memory_policy">gp_resqueue_memory_policy</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"><p>none, auto, eager_free</p><p><strong>Default</strong>: eager_free</p></td><td class="confluenceTd" colspan="1"><p align="LEFT">Enables HAWQ memory management features. When set to none, memory management is the same as in HAWQ releases prior to 4.1. When set to auto, query memory usage is controlled by statement_mem and resource queue memory limits.</p></td><td class="confluenceTd" colspan="1">local<p align="LEFT">system<br/>restart/reload</p></td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-gp_resqueue_priority">gp_resqueue_priority</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"> </td><td class="confluenceTd" colspan="1"><p align="LEFT">Enables or disables query prioritization. When this parameter is disabled, existing priority settings are not evaluated at query run time.</p> </td><td class="confluenceTd" colspan="1"><p align="LEFT">local<br/>system<br/>restart </p></td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-gp_resequeue_priority_cpucores_per_segment">gp_resequeue_priority_cpucores_per_segment</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"><p>0.1 - 25.0</p><p><strong>Default</strong>: <br/>segments = 4 <br/>master =24</p></td><td class="confluenceTd" colspan="1"><span>Specifies the number of CPU units per segment. In a configuration where one segment is </span><span>configured per CPU core on a host, this unit is 1.0 (default). If an 8-core host is configured with </span><span>four segments, the value would be 2.0. A master host typically only has one segment running </span><span>on it (the master instance), so the value for the master should reflect the usage of all available </span><span>CPU cores. Incorrect settings can result in CPU under-utilization. The default values are </span><span>appropriate for the Greenplum Data Computing Appliance.</span></td><td class="confluenceTd" colspan="1"><span>local<br/></span><span style="line-height: 1.4285;background-color: transparent;">system<br/></span><span style="line-height: 1.4285;background-color: transparent;">restart</span></td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-gp_resqueue_priority_sweeper_interval">gp_resqueue_priority_sweeper_interval</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"><p>500 - 15000 ms</p><p><strong>Default</strong>: 1000</p></td><td class="confluenceTd" colspan="1">Specifies the interval at which the sweeper process evaluates current CPU usage. When a new statement becomes active, its priority is evaluated and its CPU share determined when the next interval is reached.</td><td class="confluenceTd" colspan="1">local<p align="LEFT">system <br/>restart</p></td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-gp_role">gp_role</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1">dispatch<br/>execute<br/>utility</td><td class="confluenceTd" colspan="1">The role of this server process — set to dispatch for the master and <em>execute </em> <span style="font-size: xx-small;"> </span>for a segment.</td><td class="confluenceTd" colspan="1">read only</td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-gp_safefswritesize">gp_safefswritesize</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"><p>Integer </p><p><strong>Default</strong>: 0</p></td><td class="confluenceTd" colspan="1"><p align="LEFT">Specifies a minimum size for safe write operations to append-only tables in a non-mature file system. When a number of bytes greater than zero is specified, the append-only writer adds padding data up to that number in order to prevent data corruption due to file system errors. <br/>Each non-mature file system has a known safe write size that must be specified here when using HAWQ with that type of file system. This is commonly set to a multiple of the extent size of the file system; for example, Linux ext3 is 4096 bytes, so a value of 32768 is commonly used.</p> </td><td class="confluenceTd" colspan="1">local<p align="LEFT">system <br/>restart</p></td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-gp_segment_connect_timeout">gp_segment_connect_timeout</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"><p>Any valid time expression <br/>(number and unit)</p><p><strong>Default</strong>: 10mins</p></td><td class="confluenceTd" colspan="1">Time that the HAWQ interconnect will try to connect to a segment instance over the network before timing out. Controls the network connection timeout between master and primary segments, and primary to mirror segment replication processes.</td><td class="confluenceTd" colspan="1">local<p align="LEFT">system <br/>restart</p></td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-gp_segments_for_planner">gp_segments_for_planner</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"><p>0-n </p><p><strong>Default</strong>: 0</p></td><td class="confluenceTd" colspan="1">Sets the number of primary segment instances for the planner to assume in its cost and size estimates. If 0, then the value used is the actual number of primary segments. This variable affects the planner’s estimates of the number of rows handled by each sending and receiving process in Motion operators.</td><td class="confluenceTd" colspan="1"><p align="LEFT">master<br/>system <br/>restart</p></td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-gp_session_id">gp_session_id</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"><p>1-n </p><p><strong>Default</strong>: 14</p></td><td class="confluenceTd" colspan="1">A system assigned ID number for a client session. Starts counting from 1 when the master instance is first started.</td><td class="confluenceTd" colspan="1">read only</td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-gp_set_proc_affinity">gp_set_proc_affinity</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"><p>Boolean </p><p><strong>Default</strong>: off</p></td><td class="confluenceTd" colspan="1">If enabled, when a HAWQ server process (postmaster) is started it will bind to a CPU.</td><td class="confluenceTd" colspan="1"><p align="LEFT">master <br/>system <br/>restart </p></td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-gp_set_read_only">gp_set_read_only</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"><p>Boolean </p><p><strong>Default</strong>: off</p></td><td class="confluenceTd" colspan="1">Set to on to disable writes to the database. Any in progress transactions must finish before read-only mode takes affect.</td><td class="confluenceTd" colspan="1">master <br/>system <br/>restart</td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-gp_snmp_community">gp_snmp_community</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"><p align="LEFT">SNMP community name</p><p align="LEFT"><strong>Default</strong>: public</p> </td><td class="confluenceTd" colspan="1">Set to the community name you specified for your environment.</td><td class="confluenceTd" colspan="1">master<p align="LEFT">system<br/>reload</p></td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-gp_snmp_monitor_address">gp_snmp_monitor_address</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1">hostname:port</td><td class="confluenceTd" colspan="1">The <em>hostname:port </em> <span style="font-size: xx-small;"> </span>of your network monitor application. Typically, the port number is 162. If there are multiple monitor addresses, separate them with a comma.</td><td class="confluenceTd" colspan="1">master<p align="LEFT">system<br/>reload</p></td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-gp_snmp_use_inform_or_trap">gp_snmp_use_inform_or_trap</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1">inform<p>trap</p><p><strong>Default</strong>: trap</p></td><td class="confluenceTd" colspan="1">Trap notifications are SNMP messages sent from one application to another (for example, between HAWQ and a network monitoring application). These messages are unacknowledged by the monitoring application, but generate less network overhead. Inform notifications are the same as trap messages, except that the application sends an <br/>acknowledgement to the application that generated the alert.</td><td class="confluenceTd" colspan="1">master<br/>system<br/>reload</td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-gp_statistics_pullup_from_child_partition">gp_statistics_pullup_from_child_partition</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"><p>Boolean</p><p><strong>Default</strong>: on</p></td><td class="confluenceTd" colspan="1">Enables the query planner to utilize statistics from child tables when planning queries on the parent table.</td><td class="confluenceTd" colspan="1">master<p align="LEFT">system<br/>reload</p></td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-gp_statistics_use_fkeys">gp_statistics_use_fkeys</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"><p>Boolean</p><p><strong>Default</strong>: off</p></td><td class="confluenceTd" colspan="1">When enabled, allows the optimizer to use foreign key information stored in the system catalog to optimize joins between foreign keys and primary keys.</td><td class="confluenceTd" colspan="1">master<p align="LEFT">system<br/>reload</p></td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-gp_vmem_idle_resource_timeout">gp_vmem_idle_resource_timeout</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"><p>Any valid time expression <br/>(number and unit)</p><p><strong>Default</strong>: 18s</p></td><td class="confluenceTd" colspan="1">If a database session is idle for longer than the time specified, the session will free system resources (such as shared memory), but remain connected to the database. This allows more concurrent connections to the database at one time.</td><td class="confluenceTd" colspan="1">master<br/>system<br/>restart</td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-gp_vmem_protect_limit">gp_vmem_protect_limit</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"><p>Integer </p><p><strong>Default</strong>: 8192</p></td><td class="confluenceTd" colspan="1"><p>Sets the amount of memory (in number of MBs) that all postgres processes of an active segment instance can consume. To prevent over allocation of memory, set to:</p><p>(<em>X </em> <span style="font-size: xx-small;"> </span>* <em>physical_memory </em> <span style="font-size: xx-small;"> </span>) / primary_segments<span style="font-size: xx-small;"> </span></p><p align="LEFT">Where</p><p align="LEFT"><em>X </em> <span style="font-size: xx-small;"> </span>is a value between 1.0 and 1.5.<br/>X=1 offers the best system performance.<br/>X=1.5 may cause more swapping on the system, but less queries will be cancelled.</p><p align="LEFT">For example, on a segment host with 16GB physical memory and 4 primary segment instances the calculation would be:</p><p align="LEFT">(1 * 16) / 4 = 4GB<br/>4 * 1024 = 4096MB</p><p align="LEFT">If a query causes this limit to be exceeded, memory will not be allocated and the query will fail. Note that this is a local parameter and must be set for every segment in the system.</p></td><td class="confluenceTd" colspan="1"> </td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-gp_vmem_protect_segworker_cache_limit">gp_vmem_protect_segworker_cache_limit</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"><p>number of megabytes </p><p><strong>Default</strong>: 500</p></td><td class="confluenceTd" colspan="1"><p>If a query executor process consumes more than this configured amount, then the process will not be cached for use in subsequent queries after the process completes. Systems with lots of connections or idle processes may want to reduce this number to free more memory on the segments.</p><p>Note that this is a local parameter and must be set for every segment.</p></td><td class="confluenceTd" colspan="1">master<p align="LEFT">system<br/>restart</p></td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-gp_workfile_checksumming">gp_workfile_checksumming</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"><p>Boolean </p><p><strong>Default</strong>: on</p></td><td class="confluenceTd" colspan="1">Adds a checksum value to each block of a work file (or spill file) used by HashAgg and HashJoin query operators. This adds an additional safeguard from faulty OS disk drivers writing corrupted blocks to disk. When a checksum operation fails, the query will cancel and rollback rather than potentially writing bad data to disk</td><td class="confluenceTd" colspan="1">master<p align="LEFT">system<br/>reload</p></td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-gp_workfile_compress_algorithm">gp_workfile_compress_algorithm</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"><p>none zlib </p><p><strong>Default</strong>: none</p></td><td class="confluenceTd" colspan="1">When a hash aggregation or hash join operation spills to disk during query processing, specifies the compression algorithm to use on the spill files. If using zlib, it must be in your $PATH on all segments.</td><td class="confluenceTd" colspan="1">master<p align="LEFT">system<br/>reload</p></td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-gp_workfile_limit_per_query">gp_workfile_limit_per_query</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classifications</th></tr><tr><td class="confluenceTd"><p>kilobytes</p><p><strong>Default</strong>: 0</p></td><td class="confluenceTd">Sets the maximum disk size that the individual query can use to create temporary spill files at each segment. Since the default vale is 0, a limit is not enforced.</td><td class="confluenceTd">master<br/>session<br/>reload</td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-gpperfmon_port"> gpperfmon_port</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"><p>Integer</p><p><strong>Default</strong>: 8888</p></td><td class="confluenceTd" colspan="1">Sets the port on which all performance monitor agents communicate with the master.</td><td class="confluenceTd" colspan="1">master<br/>system<br/>restart</td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-pxf_enable_stat_collection">pxf_enable_stat_collection</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"><p>Boolean </p><p><strong>Default</strong>: on</p></td><td class="confluenceTd" colspan="1"> Collects statistical information about PXF.</td><td class="confluenceTd" colspan="1"> </td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-integer_datetimes">integer_datetimes</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"><p>Boolean</p><p><strong>Default</strong>: on</p></td><td class="confluenceTd" colspan="1">Reports whether PostgreSQL was built with support for 64-bit-integer dates and times.</td><td class="confluenceTd" colspan="1">read only </td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-IntervalStyle">IntervalStyle</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1">postgres<p align="LEFT">postgres_verbose<br/>sql_standard<br/>iso_8601</p><p align="LEFT"><strong>Default</strong>: postgres</p></td><td class="confluenceTd" colspan="1"><p align="LEFT">Sets the display format for interval values.The value <em>sql_standard </em> <span style="font-size: xx-small;"> </span>produces output matching SQL standard interval literals.</p><p align="LEFT">The value <em>postgres </em> <span style="font-size: xx-small;"> </span>produces output matching PostgreSQL releases prior to 8.4 when the DateStyle parameter was set to ISO. The value <em>postgres_verbose </em>produces output matching HAWQ releases prior to 3.3 when the DateStyle parameter was set to non-ISO output.</p><p align="LEFT">The value <em>iso_8601 </em> <span style="font-size: xx-small;"> </span>will produce output matching the time interval <em>format with </em>designators defined in section 4.4.3.2 of ISO 8601. See the PostgreSQL 8.4 documentation for more information.</p><span style="font-size: xx-small;"> </span> </td><td class="confluenceTd" colspan="1">master<br/>session<br/>reload</td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-join_collapse_limit">join_collapse_limit</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"><p> 1-n</p><p><strong>Default</strong>: 20</p></td><td class="confluenceTd" colspan="1"><p>The planner will rewrite explicit inner JOIN constructs into lists of FROM items whenever a list of no more than this many items in total would result. By default, this variable is set the same as from_collapse_limit, which is appropriate for most uses. Setting it to 1 prevents any reordering of inner JOINs. Setting this variable to a value between 1 and from_collapse_limit might be useful to trade off planning time against the quality of the chosen plan (higher values produce better plans).</p></td><td class="confluenceTd" colspan="1">master <br/>session <br/>reload</td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-krb_caseins_users">krb_caseins_users</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"><p>Boolean</p><p><strong>Default</strong>: off</p></td><td class="confluenceTd" colspan="1">Sets whether Kerberos user names should be treated case-insensitively. The default is case sensitive (off).</td><td class="confluenceTd" colspan="1">master <br/>session <br/>reload</td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-krb_server_keyfile">krb_server_keyfile</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1">path and file<p>name</p><p><strong>Default</strong>: unset</p></td><td class="confluenceTd" colspan="1">Sets the location of the Kerberos server key file.</td><td class="confluenceTd" colspan="1">master <br/>session <br/>restart</td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-krb_srvname">krb_srvname</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd"><p>service name</p><p><strong>Default</strong>: postgres</p></td><td class="confluenceTd">Sets the Kerberos service name.</td><td class="confluenceTd">master <br/>session <br/>restart </td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-krb5_ccname">krb5_ccname</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"><p>path and file name</p><p><strong>Default</strong>: /tmp/<br/>postgrres.ccname</p></td><td class="confluenceTd" colspan="1"> Set the location of the Kerberos ticket<p>cache.</p></td><td class="confluenceTd" colspan="1">master <br/>session <br/>restart </td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-lc_collate">lc_collate</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"><system dependent></td><td class="confluenceTd" colspan="1">Reports the locale in which sorting of textual data is done. The value is determined when the HAWQ array is initialized.</td><td class="confluenceTd" colspan="1">read only </td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-lc_ctype">lc_ctype</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"><system dependent></td><td class="confluenceTd" colspan="1">Reports the locale that determines character classifications. The value is determined when the HAWQ array is initialized.</td><td class="confluenceTd" colspan="1">read only </td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-lc_messages">lc_messages</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"><system dependent></td><td class="confluenceTd" colspan="1"><p align="LEFT">Sets the language in which messages are displayed. The locales available depends on what was installed with your operating system - use <em>locale -a </em> <span style="font-size: xx-small;"> </span>to list available locales. The default value is inherited from the execution environment of the server. On some systems, this locale category does not exist. Setting this variable will still work, but there will be no effect. Also, there is a chance that no translated messages for the desired language exist. In that case you will continue to see the English messages.</p></td><td class="confluenceTd" colspan="1">local<br/>system<br/>restart</td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-lc_monetary">lc_monetary</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"><system dependent> </td><td class="confluenceTd" colspan="1"><p align="LEFT">Sets the locale to use for formatting monetary amounts, for example with the to_char family of functions. The locales available depends on what was installed with your operating system - use <em>locale -a </em>to list available locales. The default value is inherited from the execution environment of the server. </p></td><td class="confluenceTd" colspan="1"><p align="LEFT">local<br/>system<br/>restart</p> </td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-lc_numeric">lc_numeric</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"><system dependent></td><td class="confluenceTd" colspan="1">Sets the locale to use for formatting numbers, for example with the <em>to_char </em>family of functions. The locales available depends on what was installed with your operating system - use <em>locale -a </em> <span style="font-size: xx-small;"> </span>to list available locales.The default value is inherited from the execution environment of the server.</td><td class="confluenceTd" colspan="1"><p>local <br/>system <br/>restart</p></td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-lc_time">lc_time</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"><p align="LEFT"><system dependent></p> </td><td class="confluenceTd" colspan="1">This parameter currently does nothing, but may in the future.</td><td class="confluenceTd" colspan="1">local<br/>system<br/>restart</td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-listen_addresses">listen_addresses</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1">localhost,host names,<p align="LEFT">IP addresses,<br/>* (all available IP interfaces)</p></td><td class="confluenceTd" colspan="1">Specifies the TCP/IP address(es) on which the server is to listen for connections from client applications - a comma-separated list of host names and/or numeric IP addresses. The special entry * corresponds to all available IP interfaces. If the list is empty, only UNIX-domain sockets can connect.</td><td class="confluenceTd" colspan="1">master<p align="LEFT">system<br/>restart</p></td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-local_preload_libraries">local_preload_libraries</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"> </td><td class="confluenceTd" colspan="1"><p align="LEFT">Comma separated list of shared library files to preload at the start of a client session.</p> </td><td class="confluenceTd" colspan="1"><p align="LEFT">local<br/>system<br/>restart</p> </td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-log_autostats">log_autostats</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1">Boolean</td><td class="confluenceTd" colspan="1">Logs information about automatic ANALYZE operations related to gp_autostats_mode and gp_autostats_on_change_threshold<span style="font-size: xx-small;"> </span></td><td class="confluenceTd" colspan="1">master<p align="LEFT">session<br/>reload<br/>superuser</p></td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-log_connections">log_connections</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"><p>Boolean</p><p><strong>Default</strong>: off</p> </td><td class="confluenceTd" colspan="1">This outputs a line to the server log detailing each successful connection. Some client programs, like psql, attempt to connect twice while determining if a password is required, so duplicate“ connection received” messages do not always indicate a problem.</td><td class="confluenceTd" colspan="1"><p align="LEFT">local<br/>system<br/>restart</p> </td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-log_disconnections">log_disconnections</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"><p>Boolean</p><p><strong>Default</strong>: off</p></td><td class="confluenceTd" colspan="1"><p align="LEFT">This outputs a line in the server log at termination of a client session, and includes the duration of the session.</p> </td><td class="confluenceTd" colspan="1">local<p align="LEFT">system<br/>restart</p></td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-log_dispatch_stats">log_dispatch_stats</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"><p>Boolean</p><p><strong>Default</strong>: off</p></td><td class="confluenceTd" colspan="1">When set to “on,” this parameter adds a log message with verbose information about the dispatch of the statement.</td><td class="confluenceTd" colspan="1">local<p align="LEFT">system<br/>restart</p></td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-log_duration">log_duration</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"><p>Boolean</p><p><strong>Default</strong>: off</p></td><td class="confluenceTd" colspan="1">Causes the duration of every completed statement which satisfies <em>log_statement </em>to be logged.</td><td class="confluenceTd" colspan="1">master<p align="LEFT">session<br/>reload<br/>superuser</p></td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-log_error_verbosity">log_error_verbosity</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"><p align="LEFT">TERSE<br/>DEFAULT<br/>VERBOSE</p><p align="LEFT"><strong>Default</strong>: DEFAULT</p> </td><td class="confluenceTd" colspan="1">Controls the amount of detail written in the server log for each message that is logged.</td><td class="confluenceTd" colspan="1">master<p align="LEFT">session<br/>reload<br/>superuser</p></td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-log_executor_stats">log_executor_stats</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"><p>Boolean</p><p><strong>Default</strong>: off</p></td><td class="confluenceTd" colspan="1"><p align="LEFT">For each query, write performance statistics of the query executor to the server log. This is a crude profiling instrument. Cannot be enabled together with <em>log_statement_stats</em>.</p></td><td class="confluenceTd" colspan="1">local<p align="LEFT">system<br/>restart</p></td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-log_hostname">log_hostname</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"><p>Boolean</p><p><strong>Default</strong>: off</p></td><td class="confluenceTd" colspan="1"><p align="LEFT">By default, connection log messages only show the IP address of the connecting host. Turning on this option causes logging of the host name as well. Note that depending on your host name resolution setup this might impose a non-negligible performance penalty. </p></td><td class="confluenceTd" colspan="1">local<p align="LEFT">system<br/>restart</p></td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-log_min_duration_statement">log_min_duration_statement</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1">number of<p align="LEFT">milliseconds, 0, -1</p><p align="LEFT"><strong>Default</strong>: -1</p></td><td class="confluenceTd" colspan="1"><p align="LEFT">Logs the statement and its duration on a single log line if its duration is greater than or equal to the specified number of milliseconds.</p><p align="LEFT">0 prints all statements and their durations.</p><p align="LEFT">-1 disables the feature. For example, if you set it to 250 then all SQL statements that run 250ms or longer will be logged. Enabling this option can be useful in tracking down unoptimized queries in your applications.</p></td><td class="confluenceTd" colspan="1">master<p align="LEFT">session<br/>reload<br/>superuser</p></td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-log_min_error_statement">log_min_error_statement</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1">DEBUG5<p align="LEFT">DEBUG4<br/>DEBUG3<br/>DEBUG2,<br/>DEBUG1<br/>INFO<br/>NOTICE<br/>WARNING<br/>ERROR<br/>FATAL<br/>PANIC</p><p align="LEFT"><strong>Default</strong>: ERROR</p></td><td class="confluenceTd" colspan="1"><p>Controls whether or not the SQL statement that causes an error condition will also be recorded in the server log. All SQL statements that cause an error of the specified level or higher are logged. The default is PANIC (effectively turning this feature off for normal use). Enabling this option can be helpful in tracking down the source of any errors that appear in the server log.</p></td><td class="confluenceTd" colspan="1">master<p align="LEFT">session <br/>reload <br/>superuser</p></td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-log_min_messages">log_min_messages</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"><p align="LEFT">DEBUG5<br/>DEBUG4<br/>DEBUG3<br/>DEBUG2<br/>DEBUG1<br/>INFO<br/>NOTICE<br/>WARNING<br/>ERROR<br/>LOG<br/>FATAL<br/>PANIC </p><p align="LEFT"><strong>Default</strong>: NOTICE</p></td><td class="confluenceTd" colspan="1">Controls which message levels arewritten to the server log. Each level includes all the levels that follow it. The later the level, the fewer messages are sent to the log.</td><td class="confluenceTd" colspan="1">master<p align="LEFT">session <br/>reload <br/>superuser</p></td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-log_parser_stats">log_parser_stats</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"><p>Boolean </p><p><strong>Default</strong>: off</p></td><td class="confluenceTd" colspan="1"><p align="LEFT">For each query, write performance statistics of the query parser to the server log. This is a crude profiling instrument. Cannot be enabled together with log_statement_stats</p></td><td class="confluenceTd" colspan="1">master<p align="LEFT">session <br/>reload <br/>superuser</p></td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-log_planner_stats">log_planner_stats</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"><p>Boolean </p><p><strong>Default</strong>: off</p></td><td class="confluenceTd" colspan="1">For each query, write performance statistics of the query planner to the server log. This is a crude profiling instrument. Cannot be enabled together with <em>log_statement_stats</em> <span style="font-size: xx-small;"> </span>.<span style="font-size: xx-small;"> </span></td><td class="confluenceTd" colspan="1">master<p align="LEFT">session <br/>reload <br/>superuser</p></td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-log_rotation_age">log_rotation_age</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"><p align="LEFT">Any valid time expression <br/>(number and unit)</p><p align="LEFT"><strong>Default</strong>: 1d</p></td><td class="confluenceTd" colspan="1"><p>Determines the maximum lifetime of an individual log file. After this time has elapsed, a new log file will becreated. Set to zero to disable time-based creation of new log files.</p></td><td class="confluenceTd" colspan="1">master<p align="LEFT">session <br/>restart</p></td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-log_rotation_size">log_rotation_size</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"><p align="LEFT">number of kilobytes</p> </td><td class="confluenceTd" colspan="1"><p align="LEFT">Determines the maximum size of an individual log file. After this many kilobytes have been emitted into a log file, a new log file will be created. Set to zero to disable size-based creation of new log files.</p></td><td class="confluenceTd" colspan="1">master<p align="LEFT">session <br/>restart</p></td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-log_statement">log_statement</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1">NONE<p align="LEFT">DDL<br/>MOD<br/>ALL</p><p align="LEFT"><strong>Default</strong>: ALL</p></td><td class="confluenceTd" colspan="1"><p align="LEFT">Controls which SQL statements are logged. DDL logs all data definition commands like CREATE, ALTER, and DROP commands. MOD logs all DDL statements, plus INSERT, UPDATE, DELETE, TRUNCATE, and COPY FROM. PREPARE and EXPLAIN ANALYZE statements are also logged if their contained command is of an appropriate type.</p></td><td class="confluenceTd" colspan="1">master<p align="LEFT">session <br/>reload <br/>superuser</p></td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-log_statement_stats">log_statement_stats</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"><p>Boolean</p><p><strong>Default</strong>: off</p></td><td class="confluenceTd" colspan="1">For each query, write total performance statistics of the query parser, planner, and executor to the server log. This is a crude profiling instrument.</td><td class="confluenceTd" colspan="1">master<p align="LEFT">session <br/>reload <br/>superuser</p></td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-log_timezone">log_timezone</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"><p>string </p><p> </p></td><td class="confluenceTd" colspan="1">Sets the time zone used for timestamps written in the log. Unlike TimeZone, this value is system-wide, so that all sessions will report timestamps consistently. The default is unknown, which means to use whatever the system environment specifies as the time zone.</td><td class="confluenceTd" colspan="1">local<br/>system<br/>restart </td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-log_truncate_on_rotation">log_truncate_on_rotation</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"><p>Boolean</p><p><strong>Default</strong>: off</p></td><td class="confluenceTd" colspan="1">Truncates (overwrites), rather than appends to, any existing log file of the same name. Truncation will occur only when a new file is being opened due to time-based rotation. For example, using this setting in combination with a log_filename such as gpseg#-%H.log would result in generating twenty-four hourly log files and then cyclically overwriting them. When off, pre-existing files will be appended to in all cases.</td><td class="confluenceTd" colspan="1">local<br/>system<br/>restart</td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-max_appendonly_tables">max_appendonly_tables</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"><p>2048 </p><p><strong>Default</strong>: 2048</p></td><td class="confluenceTd" colspan="1">Sets the maximum number of append-only relations that can be written to or loaded concurrently. Append-only table partitions and subpartitions are considered as unique tables against this limit. Increasing the limit will allocate more shared memory at server start.</td><td class="confluenceTd" colspan="1">master<p align="LEFT">session <br/>restart</p></td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-max_connections">max_connections</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"><p>10-n</p><p><strong>Default</strong>: <br/>250 on master<br/>750 on segment</p></td><td class="confluenceTd" colspan="1"><p align="LEFT">The maximum number of concurrent connections to the database server. In a HAWQ system, user client connections go through the HAWQ master instance only. Segment instances should allow 5-10 times the amount as the master. When you increase this parameter, max_prepared_transactions must be increased as well. Increasing this parameter may cause HAWQ to request more shared memory.</p></td><td class="confluenceTd" colspan="1">local <br/>system <br/>restart</td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-max_files_per_process">max_files_per_process</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"><p>Integer </p><p><strong>Default</strong>: 150</p></td><td class="confluenceTd" colspan="1">Sets the maximum number of simultaneously open files allowed to each server subprocess. If the kernel is enforcing a safe per-process limit, you don’t need to worry about this setting. Some platforms such as BSD, the kernel will allow individual processes to open many more files than the system can really support. Note. Increasing this value can improve performance of HAWQ, but bring heavier workload to HDFS.</td><td class="confluenceTd" colspan="1">local <br/>system<br/> restart</td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-max_fsm_pages">max_fsm_pages</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"><p>integer > 16 * max_fsm_relations<span style="font-size: xx-small;"> </span></p><p><span style="font-size: xx-small;"> </span></p><p><strong>Default</strong>: 20000</p></td><td class="confluenceTd" colspan="1"><p align="LEFT">Sets the maximum number of disk pages for which free space will be tracked in the shared free-space map. Six bytes of shared memory are consumed for each page slot.</p> </td><td class="confluenceTd" colspan="1"> local <br/>system <br/>restart</td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-max_fsm_relations">max_fsm_relations</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"><p>Integer</p><p><strong>Default</strong>: 1000</p></td><td class="confluenceTd" colspan="1">Sets the maximum number of relations for which free space will be tracked in the shared memory free-space map. Should be set to a value larger than the total number of: <br/>tables +system tables. It costs about 60 bytes of memory for each relation per segment instance. It is better to allow some room for overhead and set too high rather than too low.</td><td class="confluenceTd" colspan="1">local <br/>system <br/>restart </td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-max_function_args">max_function_args</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"><p>Integer</p><p><strong>Default</strong>: 100</p></td><td class="confluenceTd" colspan="1"><p align="LEFT">Reports the maximum number of function arguments.</p> </td><td class="confluenceTd" colspan="1">read only </td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-max_identifier_length">max_identifier_length</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"><p>Integer </p><p><strong>Default</strong>: 63</p></td><td class="confluenceTd" colspan="1"><p>Reports the maximum identifier length.</p> </td><td class="confluenceTd" colspan="1"> read only</td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-max_locks_per_transaction">max_locks_per_transaction</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"><p>Integer </p><p><strong>Default</strong>: 64</p></td><td class="confluenceTd" colspan="1">The shared lock table is created with room to describe locks on max_locks_per_transaction * (<em>max_connections </em> <span style="font-size: xx-small;"> </span>+ max_prepared_transactions) objects, so no more than this many distinct objects can be locked at any one time. This is not a hard limit on the number of locks taken by any one transaction, but rather a maximum average value. You might need to raise this value if you have clients that touch many different tables in a single transaction.</td><td class="confluenceTd" colspan="1">local <br/>system <br/>restart</td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-max_prepared_transactions">max_prepared_transactions</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"><p>Integer </p><p><strong>Default</strong>: <br/>250 on master<br/>250 on segments</p></td><td class="confluenceTd" colspan="1"><p align="LEFT">Sets the maximum number of transactions that can be in the prepared state simultaneously. HAWQ uses prepared transactions internally to ensure data integrity across the segments. This value must be at least as large as the value of max_connections on the master. Segment instances should be set to the same value as the master. </p></td><td class="confluenceTd" colspan="1">local <br/>system <br/>restart</td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-max_resource_portals_per_transaction">max_resource_portals_per_transaction</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"><p>Integer </p><p><strong>Default</strong>: 64</p></td><td class="confluenceTd" colspan="1"><p align="LEFT">Sets the maximum number of simultaneously open user-declared cursors allowed per transaction. Note that an open cursor will hold an active query slot in a resource queue. Used for workload management.</p> </td><td class="confluenceTd" colspan="1">master<br/>system<br/>restart </td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-max_resource_queues">max_resource_queues</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"><p>Integer </p><p><strong>Default</strong>: 8</p></td><td class="confluenceTd" colspan="1"><p align="LEFT">Sets the maximum number of resource queues that can be created in a HAWQ system. Note that resource queues are system-wide (as are roles) so they apply to all databases in the system </p></td><td class="confluenceTd" colspan="1">master<br/>system<br/>restart </td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-max_stack_depth">max_stack_depth</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"><p>number of kilobytes </p><p><strong>Default</strong>: 2MB</p></td><td class="confluenceTd" colspan="1"><p>Specifies the maximum safe depth of the server’s execution stack. The ideal setting for this parameter is the actual stack size limit enforced by the kernel (as set by ulimit -s or local equivalent), less a safety margin of a megabyte or so. Setting the parameter higher than the actual kernel limit will mean that a runaway recursive function can crash an individual backend process.</p></td><td class="confluenceTd" colspan="1">local<br/>system<br/>restart </td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-max_statement_mem">max_statement_mem</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"><p>number of kilobytes</p><p><strong>Default</strong>: 200MB</p><p> </p></td><td class="confluenceTd" colspan="1"><p>Sets the maximum memory limit for a query. Helps avoid out-of-memory errors on a segment host during query processing as a result of setting statement_mem too high. When gp_resqueue_memory_policy=auto, statement_mem and resource queue memory limits control query memoryusage. Taking into account the configuration of a single segment host, calculate this setting as follows:</p><p>(seghost_physical_memory) /(average_number_concurrent_queries)</p></td><td class="confluenceTd" colspan="1">master<br/>session<br/>reload<br/>superuser </td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-optimizer_log">optimizer_log</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"><p>Boolean</p><p><strong>Default</strong>: True</p></td><td class="confluenceTd" colspan="1">Indicates whether the new optimizer, ORCA or the existing planner produced the query execution plan. It also records the reason for using a plan generated by the existing planner. For more information about Orca and the existing planner “About Query Processing”</td><td class="confluenceTd" colspan="1"> </td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-optimizer_minidump">optimizer_minidump</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"><p align="LEFT">ONERROR/AL</p><p>WAYS</p><p><strong>Default</strong>: ONEERROR</p> </td><td class="confluenceTd" colspan="1"><p align="LEFT">The new optimizer Orca generates minidumps to describe the optimization context for a given query. You can use the information in these files to reproduce failures or performance regressions during optimization in any environment. The minidump file is located under the master data directory and uses the following naming format:</p><p align="LEFT">Minidump_<date>_<time>.mpd</p><p align="LEFT">Setting this GUC to ALWAYS, generates a minidump for all queries. Pivotal recommends that you set this GUC to ONERROR in production environments to minimize costs.</p> </td><td class="confluenceTd" colspan="1"> </td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-password_encryption">password_encryption</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"> </td><td class="confluenceTd" colspan="1"><p align="LEFT">When a password is specified in CREATE USER or ALTER USER without writing either ENCRYPTED or UNENCRYPTED, this option determines whether the password is to be encrypted.</p> </td><td class="confluenceTd" colspan="1"> </td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-port">port</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"><p>any valid port number </p><p><strong>Default</strong>: 5432</p></td><td class="confluenceTd" colspan="1"><p align="LEFT">The database listener port for a HAWQ instance. The master and each segment has its own port. You must shut down your HAWQ system before changing port numbers.</p> </td><td class="confluenceTd" colspan="1">local<br/>system<br/>restart</td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-random_page_cost">random_page_cost</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"><p>floating point</p><p><strong>Default</strong>: 100</p></td><td class="confluenceTd" colspan="1"><p align="LEFT">Sets the planner’s estimate of the cost of a nonsequentially fetched disk page. This is measured as a multiple of the cost of a sequential page fetch.</p></td><td class="confluenceTd" colspan="1">master<br/>session<br/>reload </td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-regex_flavor">regex_flavor</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"><p align="LEFT">advanced<br/>extended<br/>basic</p><p><strong>Default</strong>: advanced</p> </td><td class="confluenceTd" colspan="1">The ‘extended’ setting may be useful for exact backwards compatibility with pre-7.4 releases of PostgreSQL.</td><td class="confluenceTd" colspan="1">master <br/>session <br/>reload </td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-resource_cleanup_gangs_on_wait">resource_cleanup_gangs_on_wait</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"><p>Boolean </p><p><strong>Default</strong>: on</p></td><td class="confluenceTd" colspan="1">If a statement is submitted through a resource queue, clean up any idle query executor worker processes before taking a lock on the resource queue.</td><td class="confluenceTd" colspan="1">master <br/>session <br/>restart</td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-resource_select_only">resource_select_only</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"><p>Boolean </p><p><strong>Default</strong>: off</p></td><td class="confluenceTd" colspan="1">Sets the types of queries managed by resource queues. If set to on, then SELECT, SELECT INTO, CREATE TABLE AS SELECT, and DECLARE CURSOR commands are evaluated. If set to off INSERT, UPDATE, and DELETE commands will be evaluated as well.</td><td class="confluenceTd" colspan="1">master<br/>session<br/>reload </td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-search_path">search_path</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"><p>a comma separated list <br/>of schema names </p><p><strong>Default</strong>: $user.public</p></td><td class="confluenceTd" colspan="1">Specifies the order in which schemas are searched when an object is referenced by a simple name with no schema component. When there are objects of identical names in different schemas, the one found first in the search path is used. The system catalog schema, <em>pg_catalog</em> <span style="font-size: xx-small;"> </span>, is always searched, whether it is mentioned in the path or not. When objects are created without specifying a particular target schema, they will be placed in the first schema listed in the search path. The current effective value of the search path can be examined via the SQL function <em>current_schemas()</em> <span style="font-size: xx-small;"> </span>.current_schemas() shows how the requests appearing in <em>search_path </em> <span style="font-size: xx-small;"> </span>were resolved.</td><td class="confluenceTd" colspan="1">master <br/>session <br/>reload </td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-seq_page_cost">seq_page_cost</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"><p>floating point </p><p><strong>Default</strong>: 1</p></td><td class="confluenceTd" colspan="1"><p align="LEFT">Sets the planner’s estimate of the cost of a disk page fetch that is part of a series of sequential fetches.</p> </td><td class="confluenceTd" colspan="1">master<br/>session<br/>reload </td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-server_encoding">server_encoding</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"><p><system dependent> </p><p><strong>Default</strong>: UTF8</p></td><td class="confluenceTd" colspan="1"><p align="LEFT">Reports the database encoding (character set). It is determined when the HAWQ array is initialized. Ordinarily, clients need only be concerned with the value of <em>client_encoding</em> <span style="font-size: xx-small;"> </span>.<span style="font-size: xx-small;"> </span> </p></td><td class="confluenceTd" colspan="1"> read only</td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-server_ticket_renew_interval">server_ticket_renew_interval</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"><p>Integer </p><p><strong>Default</strong>: 43200000</p></td><td class="confluenceTd" colspan="1">Set the kerberos ticket renew interval in milliseconds</td><td class="confluenceTd" colspan="1">master<br/>system<br/>restart </td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-server_version">server_version</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"><p>String </p><p><strong>Default</strong>: 8.12.15</p></td><td class="confluenceTd" colspan="1"><p align="LEFT">Reports the version of PostgreSQL that this release of HAWQ is based on.</p></td><td class="confluenceTd" colspan="1">read only </td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-server_version_num">server_version_num</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"><p>Integer </p><p><strong>Default</strong>: 80215</p></td><td class="confluenceTd" colspan="1">Reports the version of PostgreSQL that this release of HAWQ is based on as an integer.</td><td class="confluenceTd" colspan="1">read only </td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-shared_buffers">shared_buffers</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd"><p>integer > 16K * max_connections<span> </span></p><p><strong>Default</strong>: 125MB</p></td><td class="confluenceTd"><p align="LEFT">Sets the amount of memory a HAWQ server instance uses for shared memory buffers. This setting must be at least 128 kilobytes and at least 16 kilobytes times max_connections.</p></td><td class="confluenceTd">local <br/>system <br/>restart </td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-shared_preload_libraries">shared_preload_libraries</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"> </td><td class="confluenceTd" colspan="1">A comma-separated list of shared libraries that are to be preloaded at server start. PostgreSQL procedural language libraries can be preloaded in this way, typically by using the syntax '$libdir/plXXX' where XXX is pgsql, perl, tcl, or python. By preloading a shared library, the library startup time is avoided when the library is first used. If a specified library is not found, the server will fail to start.</td><td class="confluenceTd" colspan="1">master<br/>system<br/>restart</td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-ssl">ssl</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"><p>Boolean </p><p><strong>Default</strong>: off</p></td><td class="confluenceTd" colspan="1"><p>Enables SSL connections.</p> </td><td class="confluenceTd" colspan="1">master<br/>system<br/>restart </td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-ssl_ciphers">ssl_ciphers</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"><p>string </p><p><strong>Default</strong>: ALL</p></td><td class="confluenceTd" colspan="1">Specifies a list of SSL ciphers that are allowed to be used on secure connections. See the openssl manual page for a list of supported ciphers.</td><td class="confluenceTd" colspan="1">read only </td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-standard_conforming_strings">standard_conforming_strings</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"><p>Boolean </p><p><strong>Default</strong>: off</p></td><td class="confluenceTd" colspan="1">Reports whether ordinary string literals ('...') treat backslashes literally, as specified in the SQL standard. The value is currently always off, indicating that backslashes are treated as escapes. It is planned that this will change to on in a future release when string literal syntax changes to meet the standard. Applications may check this parameter to determine how string literals will be processed. The presence of this parameter can also be taken as an indication that the escape string syntax (E'...') is supported.</td><td class="confluenceTd" colspan="1"> </td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-statement_mem">statement_mem</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1">number of kilobytes 128MB </td><td class="confluenceTd" colspan="1"><p align="LEFT">Allocates segment host memory per query. The amount of memory allocated with this parameter cannot exceed max_statement_mem or the memory limit on the resource queue through which the query was submitted. When gp_resqueue_memory_policy=auto,statement_mem and resource queue memory limits control query memory usage.</p> </td><td class="confluenceTd" colspan="1">master<br/>session<br/>reload</td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-statement_timeout">statement_timeout</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"><p>number of milliseconds</p><p><strong>Default</strong>: 0</p></td><td class="confluenceTd" colspan="1">Abort any statement that takes over the specified number of milliseconds. 0 turns off the limitation.</td><td class="confluenceTd" colspan="1">master<br/>session<br/>reload </td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-stats_queue_level">stats_queue_level</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"><p>Boolean </p><p><strong>Default</strong>: off</p></td><td class="confluenceTd" colspan="1">Collects resource queue statistics on database activity.</td><td class="confluenceTd" colspan="1">local<br/>system<br/>restart </td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-superuser_reserved_connections">superuser_reserved_connections</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"><p align="LEFT">integer < max_connections</p><p><strong>Default</strong>: 3</p><span style="font-size: xx-small;"> </span> </td><td class="confluenceTd" colspan="1"><p align="LEFT">Determines the number of connection slots that are reserved for HAWQ superusers.</p> </td><td class="confluenceTd" colspan="1">local<br/>system<br/>restart </td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-tcp_keepalives_count">tcp_keepalives_count</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"><p>number of keepalives </p><p><strong>Default</strong>: 0</p></td><td class="confluenceTd" colspan="1">How many keepalives may be lost before the connection is considered dead. A value of 0 uses the system default. If TCP_KEEPCNT is not supported, this parameter must be 0. Use this parameter for all connections that are not between a primary and mirror segment. Use gp_filerep_tcp_keepalives_count for settings that are between a primary and mirror segment.</td><td class="confluenceTd" colspan="1">local<br/>system<br/>restart </td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-tcp_keepalives_idle">tcp_keepalives_idle</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"><p>number of seconds </p><p><strong>Default</strong>: 0</p></td><td class="confluenceTd" colspan="1">Number of seconds between sending keepalives on an otherwise idle connection. A value of 0 uses the system default. If TCP_KEEPIDLE is not supported, this parameter must be 0. Use this parameter for all connections that are not between a primary and mirror segment. Use gp_filerep_tcp_keepalives_idle for settings that are between a primary and mirror segment.</td><td class="confluenceTd" colspan="1">local<br/>system<br/>restart </td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-tcp_keepalives_interval">tcp_keepalives_interval</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"><p>number of seconds </p><p><strong>Default</strong>: 0</p></td><td class="confluenceTd" colspan="1"><p>How many seconds to wait for a response to a keepalive before retransmitting. A value of 0 uses the system default. If TCP_KEEPINTVL is not supported, this parameter must be 0. Use this parameter for all connections that are not between a primary and mirror segment. Use gp_filerep_tcp_keepalives_interval for settings that are between a primary and mirror segment.</p></td><td class="confluenceTd" colspan="1"><p>local<br/>system<br/>restart</p></td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-temp_buffers">temp_buffers</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"><p>Integers </p><p><strong>Default</strong>: 1024</p></td><td class="confluenceTd" colspan="1">Sets the maximum number of temporary buffers used by each database session. These are session-local buffers used only for access to temporary tables. The setting can be changed within individual sessions, but only up until the first use of temporary tables within a session. The cost of setting a large value in sessions that do not actually need a lot of temporary buffers is only a buffer descriptor, or about 64 bytes, per increment. However if a buffer is actually used, an additional 8192 bytes will be consumed.</td><td class="confluenceTd" colspan="1">master<br/>session<br/>reload </td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-TimeZone">TimeZone</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"><p>time zone abbreviation</p></td><td class="confluenceTd" colspan="1">Sets the time zone for displaying and interpreting time stamps. The default is to use whatever the system environment specifies as the time zone. See Date/Time Keywords in the PostgreSQL documentation.</td><td class="confluenceTd" colspan="1">local<br/>restart </td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-timezone_abbreviations">timezone_abbreviations</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"><p>string </p><p> </p></td><td class="confluenceTd" colspan="1">Sets the collection of time zone abbreviations that will be accepted by the server for date time input. The default is Default, which is a collection that works in most of the world. Australia and India, and other collections can be defined for a particular installation. Possible values are names of configuration files stored in /share/postgresql/timezonesets/ in the installation directory.</td><td class="confluenceTd" colspan="1">master<br/>session<br/>reload</td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-track_activities">track_activities</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"><p>Boolean </p><p><strong>Default</strong>: on</p></td><td class="confluenceTd" colspan="1"><p align="LEFT">Enables the collection of statistics on the currently executing command of each session, along with the time at which that command began execution. When enabled, this information is not visible to all users, only to superusers and the user owning the session. This data can be accessed via the <em>pg_stat_activity </em> <span style="font-size: xx-small;"> </span>system view. </p></td><td class="confluenceTd" colspan="1">master<br/>session<br/>reload </td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-track_counts">track_counts</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"><p>Boolean </p><p><strong>Default</strong>: off</p></td><td class="confluenceTd" colspan="1">Enables the collection of row and block level statistics on database activity. If enabled, the data that is produced can be accessed via the <em>pg_stat </em> <span style="font-size: xx-small;"> </span>and <em>pg_statio </em>family of system views.</td><td class="confluenceTd" colspan="1">local<br/>system<br/>restart</td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-transaction_isolation">transaction_isolation</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"><p>read<br/>committed<br/>serializable</p></td><td class="confluenceTd" colspan="1"><p align="LEFT">Sets the current transaction’s isolation level.</p> </td><td class="confluenceTd" colspan="1">master<br/>system<br/>reload </td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-transaction_read_only">transaction_read_only</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"><p>Boolean</p><p><strong>Default</strong>: off</p></td><td class="confluenceTd" colspan="1"><p align="LEFT">Sets the current transaction’s read-only status.</p></td><td class="confluenceTd" colspan="1">master<br/>session<br/>reload </td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-transform_null_equals">transform_null_equals</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"><p> Boolean</p><p><strong>Default</strong>: off</p></td><td class="confluenceTd" colspan="1"><p align="LEFT">When on, expressions of the form expr = NULL (or NULL = expr) are treated as expr IS NULL, that is, they return true if expr evaluates to the null value, and false otherwise. The correct SQL-spec-compliant behavior of expr = NULL is to always return null (unknown).</p></td><td class="confluenceTd" colspan="1">master<br/>session<br/>reload</td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-unix_socket_directory">unix_socket_directory</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"><p>directory path</p><p><strong>Default</strong>: unset</p></td><td class="confluenceTd" colspan="1"><p align="LEFT">Specifies the directory of the UNIX-domain socket on which the server is to listen for connections from client applications.</p> </td><td class="confluenceTd" colspan="1">local<br/>system<br/>restart </td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-unix_socket_group">unix_socket_group</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"><p>UNIX group name</p><p><strong>Default</strong>: unset</p> </td><td class="confluenceTd" colspan="1">Sets the owning group of the UNIX-domain socket. By default this is an empty string, which uses the default group for the current user.</td><td class="confluenceTd" colspan="1"> local<br/>system<br/>restart</td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-unix_socket_permissions">unix_socket_permissions</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1">Numeric UNIX file permission mode (as accepted by the <em>chmod </em> or umask commands)<p><strong>Default</strong>: 511</p></td><td class="confluenceTd" colspan="1"><p align="LEFT">Sets the access permissions of the UNIX-domain socket. UNIX-domain sockets use the usual UNIX file system permission set. Note that for a UNIX-domain socket, only write permission matters.</p> </td><td class="confluenceTd" colspan="1">local<br/>system<br/>restart </td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-update_process_title">update_process_title</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"><p align="LEFT">Boolean</p><p><strong>Default</strong>: on</p></td><td class="confluenceTd" colspan="1">Enables updating of the process title every time a new SQL command is received by the server. The process title is typically viewed by the ps command.<span style="font-size: xx-small;"> </span></td><td class="confluenceTd" colspan="1">local<br/>system<br/>restart </td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-vacuum_cost_delay">vacuum_cost_delay</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"><p align="LEFT">milliseconds < 0 (in multiples of 10)</p><p><strong>Default</strong>: 0</p></td><td class="confluenceTd" colspan="1"><p align="LEFT">The length of time that the process will sleep when the cost limit has been exceeded. 0 disables the cost-based vacuum delay feature.</p> </td><td class="confluenceTd" colspan="1">local<br/>system<br/>restart </td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-vacuum_cost_limit">vacuum_cost_limit</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"><p>Integer > 0</p><p><strong>Default</strong>: 200</p></td><td class="confluenceTd" colspan="1"><p align="LEFT">The accumulated cost that will cause the vacuuming process to sleep.</p> </td><td class="confluenceTd" colspan="1">local<br/>system<br/>restart </td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-vacuum_cost_page_dirty">vacuum_cost_page_dirty</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"><p>Integer > 0</p><p><strong>Default</strong>: 20</p></td><td class="confluenceTd" colspan="1"><p align="LEFT">The estimated cost charged when vacuum modifies a block that was previously clean. It represents the extra I/O required to flush the dirty block out to disk again.</p></td><td class="confluenceTd" colspan="1">local<br/>system<br/>restart </td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-vacuum_cost_page_hit">vacuum_cost_page_hit</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"><p>Integer > 0</p><p><strong>Default</strong>: 1</p></td><td class="confluenceTd" colspan="1">The estimated cost for vacuuming a buffer found in the shared buffer cache. It represents the cost to lock the buffer pool, lookup the shared hash table and scan the content of the page.</td><td class="confluenceTd" colspan="1">local<br/>system<br/>restart </td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-vacuum_cost_page_miss">vacuum_cost_page_miss</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"><p>Integer > 0</p><p><strong>Default</strong>: 10</p> </td><td class="confluenceTd" colspan="1">The estimated cost for vacuuming a buffer that has to be read from disk. This represents the effort to lock the buffer pool, lookup the shared hash table, read the desired block in from the disk and scan its content.</td><td class="confluenceTd" colspan="1">local<br/>system<br/>restart</td></tr></tbody></table></div><h3 id="HAWQServerConfigurationParameters-vacuum_freeze_min_age">vacuum_freeze_min_age</h3><div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Value Range</th><th class="confluenceTh">Description</th><th class="confluenceTh">Set Classification</th></tr><tr><td class="confluenceTd" colspan="1"><p>Integer</p><p>0-100000000000</p><p><strong>Default</strong>: 100000000</p></td><td class="confluenceTd" colspan="1"><p>Specifies the cutoff age (in transactions) that VACUUM should use to decide whether to replace transaction IDs with FrozenXID while scanning a table. VACUUM will limit the effective value to half the value of autovacuum_freeze_max_age, so that there is not an unreasonably short time between forced autovacuums.</p> </td><td class="confluenceTd" colspan="1">local<br/>system<br/>restart </td></tr></tbody></table></div><p align="LEFT"><span style="font-size: medium;"> </span></p><p> </p>
</div></div>
</div><!-- end of content-->
</div><!-- end of container -->
</div><!--end of container-fluid-->
</div><!--end of main-wrap-->
<div class="site-footer desktop-only">
<div class="container-fluid">
<div class="site-footer-links">
<span class="version"><a href='/'>Pivotal Documentation</a></span>
<span>©
<script>
var d = new Date();
document.write(d.getFullYear());
</script>
<a href='http://gopivotal.com'>Pivotal Software</a> Inc. All Rights Reserved.
</span>
</div>
</div>
</div>
<script type="text/javascript">
(function() {
var didInit = false;
function initMunchkin() {
if(didInit === false) {
didInit = true;
Munchkin.init('625-IUJ-009');
}
}
var s = document.createElement('script');
s.type = 'text/javascript';
s.async = true;
s.src = document.location.protocol + '//munchkin.marketo.net/munchkin.js';
s.onreadystatechange = function() {
if (this.readyState == 'complete' || this.readyState == 'loaded') {
initMunchkin();
}
};
s.onload = initMunchkin;
document.getElementsByTagName('head')[0].appendChild(s);
})();
</script>
</div><!--end of viewport-->
<div id="scrim"></div>
</body>
</html>