* docs - add info about moving a query to a different resource group

* need to be superuser

* remove upgrade/downgrade info for master

Cluster on AO tables is implemented by sorting the entire AO table using
tuple sort framework, according to a btree index defined on the table.

A faster way to cluster is to scan the tuples in index-order, but this
requires index-scan support.  Append-optimized tables do not support
index-scans currently, but when this support is added, the cluster
operation can be enhanced accordingly.

Author: Andrey Borodin <amborodin@acm.org>
Reviewed and slightly edited by: Asim R P <pasim@vmare.com>

Merges GitHub PR #9996

* docs - update bloat best practices

information from dev.
--Remove copying or redistributing table data as alternatives to VACUUM FULL
--Mention that VACUUM (without FULL) maintenance is for both heap and AO tables.

Also
Reorganized information.
Clarified ACCESS EXCLUSIVE lock is reason users cannot access table during VACUUM FULL

* docs - updates based on review comments.

* docs - removed warning about stopping VACUUM FULL.

* docs - add Note about host requirements to segment mirror overview

-also edited some related topics and changed some links
-fixed a bad link to the gpcheck utiltiy (removed in GPDB 6)

* docs - minor edit
Co-authored-by: NDavid Yozie <dyozie@pivotal.io>

* docs - add information about view dependency

-example queries to find dependency information
-catalog table information
-best practices

* docs - minor edits and fixes.

* docs - fix minor typo.

* docs - another minor edit.

* clarifying pg_upgrade note

* adding VACUUM note for gpexpand

* gpexpand edits

* small edit

* edits after review

Correctly capitalize Zstandard, and remove multiple trailing periods
in sentences.
Reviewed-by: NMel Kiyama <mkiyama@pivotal.io>

* docs - updates to Encrypting Client/Server Connections

clarified/enhanced SSL configuration information.

* docs - minor edit

* docs - add deflate support for s3 protocol

* docs - review updates for s3 protocol compressed file information

* docs - clarified how s3 protocol recognizes gzip, deflate compressed files.

* docs - CREATE FUNCTION - new EXECUTE ON INITPLAN attribute

Updated
CREATE FUNCTION
ALTER FUNCTION
Using Functions and Operators

This will be backported to 6X_STABLE

HTML output on temporary GPDB doc review site
https://docs-msk-gpdb6-dev.cfapps.io/7-0/ref_guide/sql_commands/CREATE_FUNCTION.html

https://docs-msk-gpdb6-dev.cfapps.io/7-0/ref_guide/sql_commands/ALTER_FUNCTION.html
https://docs-msk-gpdb6-dev.cfapps.io/7-0/admin_guide/query/topics/functions-operators.html

* docs - update EXECUTE ON INITPLAN attribute description based on review comments.
Labeled the attribute as Beta.

* docs - removed Beta note, fixed minor errors and typos.

* docs - fix some xrefs and conditionalize

* update a link

Synch. docs with backup/restore 1.17

* docs - additional updates for removal of gpperfmon

* remove XXX placeholder

* edits requested by david

* remove an unused file

It didn't really provide any security over the default md5 method. And in
PostgreSQL v10, we'll get SCRAM authentication, which is stronger. To
reduce conflicts with the PostgreSQL v10 merge, remove this GPDB-specific
feature now.

This also adds a check to pg_upgrade. I opted to refuse the upgrade if
there are any SHA-256 hashed passwords. Alternatively, we could clear the
passwords after upgrade, but it seems better to give the user a heads up.
Reviewed-by: NDaniel Gustafsson <dgustafsson@pivotal.io>

This fixes multiple occurrences of duplicated words in sentences, like
"the the" and "is is" etc.
Reviewed-by: NMel Kiyama <mkiyama@pivotal.io>
Reviewed-by: NHeikki Linnakangas <hlinnakangas@pivotal.io>

* reorganize ddboost replication information.

--move replication info. into separate topic.
--update toc

* docs - updated docs based on review comments.
--created sections for gpbackup and gpbackup_manager
--added link to example config. files.

* docs - resource group support of runaway query detection

update GUC runaway_detector_activation_percent
Add cross reference in
--Admin Guide resource group memory management topic
--CREATE RESOURCE GROUP parameter MEMORY_AUDITOR

This will be backported to 5X)_STABLE

* docs - minor edit

* docs - review comment updates

* docs - simplified description for resource groups
--replaced requirement for vmtracker mem. auditor w/ admin_group, and default_group
--Added global shared memory example from Simon

* docs - created an Admin Guide section for resource group automatic query termination.

* docs - fix math error

Squashed commit of the following

commit e76c278c96f49f21ee0464097e55ff7d6fc2568e
Merge: 9a14adba 98a67e1197
Author: dyozie <dyozie@pivotal.io>
Date:   Mon Feb 3 14:01:01 2020 -0800

    Merge branch 'feature/docs-analytics-2' of git://github.com/lenapivotal/gpdb into lenapivotal-feature/docs-analytics-2

commit 98a67e1197d0156e791739ba4239ac9fd34c3346
Author: Lena Hunter <lhunter@pivotal.io>
Date:   Thu Jan 23 13:38:03 2020 -0800

    edits from most recent review

commit 0b203c8a1f33293cc8276b81c8ef8b6293178d27
Author: Lena Hunter <lhunter@pivotal.io>
Date:   Mon Jan 13 16:16:05 2020 -0800

    link fixes

commit 388d3f9499f54174a48e448ab9c7e84865bd217a
Author: Lena Hunter <lhunter@pivotal.io>
Date:   Mon Jan 13 15:46:15 2020 -0800

    changes for 6.x -> 7.0 and link fixes

commit 57eaafb142badb685ade787a7e8a3b621289c125
Author: Lena Hunter <lhunter@pivotal.io>
Date:   Mon Jan 13 14:14:18 2020 -0800

    fixing gp version

commit cb4be6ade0319312a5c9cc9fd49c6c321c16981f
Merge: 944bb49b71 5e98376148
Author: Lena Hunter <lhunter@pivotal.io>
Date:   Mon Jan 13 13:57:59 2020 -0800

    resolving conficts

commit 944bb49b71bcf38803336662e081c628352cb53e
Author: Lena Hunter <lhunter@pivotal.io>
Date:   Mon Jan 6 14:36:17 2020 -0800

    adding menu times

    overview title change

    edits to intro for PL

commit 09c0a07f2cf5a3e62723b024aae812678bd83952
Author: Lena Hunter <lhunter@pivotal.io>
Date:   Fri Dec 27 12:27:44 2019 -0800

    edits from feedback

commit f1ac6bebc07b99dcc61b747723d8dcf79bc7a883
Author: Lena Hunter <lhunter@pivotal.io>
Date:   Fri Dec 13 16:16:25 2019 -0800

    changes for new text.xml page

commit 82221149283732615cd51f0cf0f63b1318a30963
Author: Lena Hunter <lhunter@pivotal.io>
Date:   Wed Dec 11 10:20:52 2019 -0800

    madlib page changes with diagram

commit 4ef989ca69aae6a132c5e6b0ff79ca963b441f45
Author: Lena Hunter <lhunter@pivotal.io>
Date:   Mon Dec 9 16:10:52 2019 -0800

    small edit for DITA format

commit e39cfbfaca820fde9047574f7722bf8d9c63eb60
Author: Lena Hunter <lhunter@pivotal.io>
Date:   Mon Dec 9 14:29:25 2019 -0800

    edits to phase 1 menu

commit 5a88a930240f719755a4c1c535ba3dd726f9241e
Author: Lena Hunter <lhunter@pivotal.io>
Date:   Mon Dec 9 13:56:00 2019 -0800

    edits to MADlib overview

commit b3da2616e48ab840cbcde5002520b33de35286f7
Author: Lena Hunter <lhunter@pivotal.io>
Date:   Mon Nov 11 15:07:37 2019 -0800

    analytics edits

commit ccdbdcb0fe34216e6ad5fbde9594e408ac470636
Author: Lena Hunter <lhunter@pivotal.io>
Date:   Mon Nov 11 14:10:51 2019 -0800

    further edits to overview page

commit db3679cd2ff1cf5a944518be06dec1526e208d8b
Author: Lena Hunter <lhunter@pivotal.io>
Date:   Mon Nov 4 14:46:05 2019 -0800

    edits to gp analytics

commit 54679c104ab5823acca6a8f11a934136f51fe3c3
Author: Lena Hunter <lhunter@pivotal.io>
Date:   Thu Oct 31 16:34:02 2019 -0700

    changes to analytics subject:

commit 40c4e35e22529ddd13e5e5f2fbe1c946c5581fd1
Author: Lena Hunter <lhunter@pivotal.io>
Date:   Thu Oct 31 16:32:00 2019 -0700

    updates to analytics work

commit caa37b01e869b106c6c2d52feecf4614d169f6a9
Author: Lena Hunter <lhunter@pivotal.io>
Date:   Thu Oct 31 14:42:57 2019 -0700

    further edits to analytics

commit 318a742a17f405725848670f89cccec2fbda55ba
Author: Lena Hunter <lhunter@pivotal.io>
Date:   Fri Oct 25 15:38:32 2019 -0700

    menu order change

commit a01c62da78154e45873dc31b8f84e6ac0dac337e
Author: Lena Hunter <lhunter@pivotal.io>
Date:   Fri Oct 25 10:54:32 2019 -0700

    added graphics folder for analytics

commit c76c1b9db711d3c14d2779031c7a7e4580e82016
Author: Lena Hunter <lhunter@pivotal.io>
Date:   Thu Oct 24 16:31:02 2019 -0700

    fixing xml error and image location/size

commit 67c7d37f909f65768c3473ec943f77697a4f5e80
Author: Lena Hunter <lhunter@pivotal.io>
Date:   Thu Oct 24 16:09:09 2019 -0700

    ditamaps and erb edits for menus

commit b6be012de62fffc442647b4469ed8ac81e1da432
Author: Lena Hunter <lhunter@pivotal.io>
Date:   Thu Oct 24 13:41:23 2019 -0700

    changes relating to ditamaps

commit c3ac846df5dfba0fd2a77b99b3eeede0fd168f13
Author: Lena Hunter <lhunter@pivotal.io>
Date:   Thu Oct 24 08:34:46 2019 -0700

    adding new overview page

commit a6c37d7a709c2907ac504e40eb81b32427ddae79
Author: Lena Hunter <lhunter@pivotal.io>
Date:   Wed Oct 23 15:12:43 2019 -0700

    testing image insert

commit 3045f7d8164df04ceb133973616d4ff45f06d5d2
Author: Lena Hunter <lhunter@pivotal.io>
Date:   Wed Oct 23 14:46:06 2019 -0700

    fixes to ref links

commit 5693353a94878a65fec8d0f3c4458afbd47b8fc5
Author: Lena Hunter <lhunter@pivotal.io>
Date:   Wed Oct 23 14:38:22 2019 -0700

    fixes for broken ref links

commit d1b389f87a20d3a7eba22d97d59e45c1fc4021f1
Author: Lena Hunter <lhunter@pivotal.io>
Date:   Tue Oct 22 16:36:58 2019 -0700

    changes to analytics section

commit 8c6a9b41f4228cdeba9a00389766c82a00effae8
Author: Lena Hunter <lhunter@pivotal.io>
Date:   Tue Oct 22 16:08:24 2019 -0700

    initial reorg of analytics work

commit 5e983761481b49c58a1025fc3a394e3b8ab3fa3a
Author: Lena Hunter <lhunter@pivotal.io>
Date:   Mon Jan 6 14:36:17 2020 -0800

    adding menu times

    overview title change

    edits to intro for PL

commit e94ffe63c665b3badb09ebd08bcd12605701ed75
Author: Lena Hunter <lhunter@pivotal.io>
Date:   Fri Dec 27 12:27:44 2019 -0800

    edits from feedback

commit 3060c37ab2c5aaa94e72e5f2df12e2b6089d32d1
Author: Lena Hunter <lhunter@pivotal.io>
Date:   Fri Dec 13 16:16:25 2019 -0800

    changes for new text.xml page

commit 43c0cbf4ad932c7b4b72a21de004a46b3e7abfd5
Author: Lena Hunter <lhunter@pivotal.io>
Date:   Wed Dec 11 10:20:52 2019 -0800

    madlib page changes with diagram

commit 57d06c23097607c1507d5908bd706a38b4de1b46
Author: Lena Hunter <lhunter@pivotal.io>
Date:   Mon Dec 9 16:10:52 2019 -0800

    small edit for DITA format

commit 2e5bf3be7f479a5fe5921b91b0aaaa8ed25d255b
Author: Lena Hunter <lhunter@pivotal.io>
Date:   Mon Dec 9 14:29:25 2019 -0800

    edits to phase 1 menu

commit 75a33778ee4dc6f013d8cd1e8c8fbb0cd4b0b083
Author: Lena Hunter <lhunter@pivotal.io>
Date:   Mon Dec 9 13:56:00 2019 -0800

    edits to MADlib overview

commit da1301b13837f7bbac96e139a37a06b0c693f0be
Author: Lena Hunter <lhunter@pivotal.io>
Date:   Mon Nov 11 15:07:37 2019 -0800

    analytics edits

commit 5b98b31fcac8a2905b4c2cc6d30dbed41e04345e
Author: Lena Hunter <lhunter@pivotal.io>
Date:   Mon Nov 11 14:10:51 2019 -0800

    further edits to overview page

commit 9d68eea525c3f07af3bb4269371ba54178204906
Author: Lena Hunter <lhunter@pivotal.io>
Date:   Mon Nov 4 14:46:05 2019 -0800

    edits to gp analytics

commit 8eb2988d6b8d5027dba247ada3dd3cc58ce97f67
Author: Lena Hunter <lhunter@pivotal.io>
Date:   Thu Oct 31 16:34:02 2019 -0700

    changes to analytics subject:

commit 1c1fdffabb0036413509084afe4caa2e58cec110
Author: Lena Hunter <lhunter@pivotal.io>
Date:   Thu Oct 31 16:32:00 2019 -0700

    updates to analytics work

commit 14bfaa14ca9c3e5873522a2cd0a485ed291698b0
Author: Lena Hunter <lhunter@pivotal.io>
Date:   Thu Oct 31 14:42:57 2019 -0700

    further edits to analytics

commit adc11169f1dcac9ab92f9d5ec1dfbd080fac6df3
Author: Lena Hunter <lhunter@pivotal.io>
Date:   Fri Oct 25 15:38:32 2019 -0700

    menu order change

commit 84dbee9d8de0d245372c8858254b0eab3d8fa0b3
Author: Lena Hunter <lhunter@pivotal.io>
Date:   Fri Oct 25 10:54:32 2019 -0700

    added graphics folder for analytics

commit bd66357bd577eb967b765a3740db145ce17a44cd
Author: Lena Hunter <lhunter@pivotal.io>
Date:   Thu Oct 24 16:31:02 2019 -0700

    fixing xml error and image location/size

commit 8836b5f9dd262d06582497be398c91d9385ccb1b
Author: Lena Hunter <lhunter@pivotal.io>
Date:   Thu Oct 24 16:09:09 2019 -0700

    ditamaps and erb edits for menus

commit 3472e6cc9dae118239651bd9447fcc996b8c52e7
Author: Lena Hunter <lhunter@pivotal.io>
Date:   Thu Oct 24 13:41:23 2019 -0700

    changes relating to ditamaps

commit 7df800760b834bcbd37746f2248e7696dcf497a9
Author: Lena Hunter <lhunter@pivotal.io>
Date:   Thu Oct 24 08:34:46 2019 -0700

    adding new overview page

commit df01bfa4f9bb18c99bbbf93b089c27b69e953ad4
Author: Lena Hunter <lhunter@pivotal.io>
Date:   Wed Oct 23 15:12:43 2019 -0700

    testing image insert

commit f34ca13d9842f844af2fb06846981bea7c63ff9b
Author: Lena Hunter <lhunter@pivotal.io>
Date:   Wed Oct 23 14:46:06 2019 -0700

    fixes to ref links

commit 17d98775fb142efc760c404a402d85493bf9bf0b
Author: Lena Hunter <lhunter@pivotal.io>
Date:   Wed Oct 23 14:38:22 2019 -0700

    fixes for broken ref links

commit 9d35b209e1bae9933fd85cec8df7b4b6f73036ec
Author: Lena Hunter <lhunter@pivotal.io>
Date:   Tue Oct 22 16:36:58 2019 -0700

    changes to analytics section

commit 7e5de7a01d506158ef106a494f2fdfe679cb25f5
Author: Lena Hunter <lhunter@pivotal.io>
Date:   Tue Oct 22 16:08:24 2019 -0700

    initial reorg of analytics work

doc PR https://github.com/pivotal/gp-docs-backup-restore/pull/5

* docs - updates to configuring windows client for kerberos auth docs

* need to set PGGSSLIB before running greenplum_clients_path.bat

* add the AD info back into the file, but comment out

* misc edit

* identify config step for custom kerb config file location

* include automated task example in generating keytab section

* note that an additional step requires admin privileges

* reinstate, but comment out, an AD statement

* remove dangling reference to AD user name

* docs - remove analyzedb option --skip_root_stats

* docs - update ANALYZE ROOTPARTITION information based on review comments

* docs - update ANALYZE ROOTPARTITION information based on review comments.

* docs - corrected ANALYZE ROOTPARTITION information.
previous version was not correct.

* docs - more updates to  ANALYZE ROOTPARTITION information.

* Add deletebackup to gpbackup plugin api

* Edits from review comments

* Add plugin-config option to the delete-backup command syntax

* Add password encryption parameters to ddboost config file.

Add gpbackup_manager reference.

All of this content is conditionalized because it is unavailble in opensource GPDB.

* Updates from review

* From review - remove stray 'L'

It's not hard to come up with an example where 'on' produces worse
estimates than 'off', but I can't come up with a realistic scenario where
'on' would produce a better plan than 'off'. Let's disable it, and save
some cycles on catalog lookups during planning. I'd like to remove it
altogether, but let's play it safe and mark it as deprecated for a release
or two first.

The documentation already claimed that the default was 'off', which was
wrong before. Move it from the "Join Operator Configuration Parameters"
section to "Other Query Planner Configuration Parameters", as it's not
really related to joins. Change the description of the GUC more accurate
in the docs, and mention that it is deprecated and will be removed in the
future.

This changed one plan in one the regression suite, in 'explain_format'
test. The query contains a join between two tables, 'apples' and 'boxes',
and the 'boxes' table is empty. (There's a third table involved in the
query, but it's not interesting for gp_statistics_use_fkeys). With
gp_statistics_use_fkeys=on, the planner estimates that the 'boxes' table
has 100000 distinct rows, because that's how many rows the 'apples' table
has. With gp_statistics_use_fkeys=off, it uses the default estimate of
1000 rows. Both esimates, of course, the table actually has 0 rows, but
it's not a very interesting case. Either plan is fine in practice.

Discussion: https://groups.google.com/a/greenplum.org/d/msg/gpdb-dev/dipq82v83PU/ro4gT1EXAgAJReviewed-by: NMel Kiyama <mkiyama@pivotal.io>

* docs - materialized views

--Added/updated commands
--Added/updated catalog views
--Added/updated Admin. Guide topics

* docs - update summary for materialized views

* docs - fix typo in pg_matviews

* docs -  materialized view review comment updates

* docs - review comment updates.

* expanding the deprecation note

* added edits to java/perl/python/r

* small edits based on review

* edits from David's review

* changes to OS parameters page org

* adding links for sysctl reorg

* added links to sysctl section

* fixing xref element issue

* sysctl reorg few edits

* chuck's review edits

* updates from review comments

* updates from review comments

* mel's last comments and html->xml edits

* remove titles from xref links