Build artifacts filled up the disk, so for now we will clean up no
matter what.

The AIX test appears to have issues if there are concurrent pipelines
going against it. The resource pool protects this failure case.
Signed-off-by: NKris Macoskey <kmacoskey@pivotal.io>

Upstream commit 220db7cc replaced all the idiomatic DirectFunctionCalls
of textin/textout, to use these new handy macros instead. Do the same
for all the remaining such calls in GPDB-specific code.

This is good for Ubuntu, CentOS, and SLES -- we shouldn't have needed to
change it
Signed-off-by: NGoutam Tadi <gtadi@pivotal.io>

Signed-off-by: NKaren Huddleston <khuddleston@pivotal.io>

This is a temporary affordance to make renaming the file transition
smoother
Signed-off-by: NGoutam Tadi <gtadi@pivotal.io>

A slot maybe reused on QE while its still using by another QE which
might causes runtime error. This issue exists for a long time in theory,
but the fail rate is enlarged with a current commit 8005f559.

To workaround the issue we change the free slot pool from a stack into a
queue, slots are allocated from the head and freed to the tail, so a
slot will not be reused immediately after being freed.

In worst case all the in-use slots are not freed in time on QEs, so we
also doubled the slot pool size to have enough free slots for new
queries even in such a worst case.

In any sense this is not a fix, just a quick workaround, we will keep
working on this race condition issue. Once a root fix is ready this
workaround will be replaced.

- Add paramiko files to PYLIB_DIR

[#151180202]
Signed-off-by: NC.J. Jameson <cjameson@pivotal.io>

- Open Source GPDB compile
- No ORCA yet -- getting there soon

[#151180202]
Signed-off-by: NGoutam Tadi <gtadi@pivotal.io>

Don't transform large array Const into ArrayExpr for Orca (#3406)

If the number of elements in the array Const is greater than
optimizer_array_expansion_threshold, returns the original Const unmodified.
Otherwise, it will cause severe performance issue for Orca optimizer for array
with very large number of elements, e.g. 50K.

Fixes issue #3355
[#151340976]

* Preliminary update to numbering and supported functions

* Screenshots for pgAdmin4

* New pgAdmin files and updates

* Fix typo in ditamap

* Resize graphics

* Move graphics to correct level graphics directory, update refs

* Add queryscreen

* Misc reorganization, add Viewing DDL file, map entry.

* Change spurious .dita postfix to .xml

* Specify what is not supported, add additional query content.

* Updates from pull request review

* Updates from Shirley Wang

* Removing sections for unsupported features

* Remove pgAdmin III pages, add link to website.

* docs: gptransfer - add sha-256 option for --validate option

* update based on review comments.
--changed option value from sha-256 to sha256
--move GPDB 4.3.x information to the notes section.

* Update/clarify based on review comments.
--clarified GPDB 4.3.x pgcrypto information.
--clarified --validate options.

* docs: minor update

* Conditionalizing the pivotal reference

* Extending conditionalized phrase to cover 4.3 stuff.

Explain analyze with explain_memory_verbosity set to 'detail' or 'summary' will show total memory used accross slices

We will be adding an extra line detailing total memory used across slices to explain analyze. This will help us in
profiling memory usage from TPC-DS benchmark.

```
(slice0)    Executor memory: 322K bytes.  Peak memory: 11783K bytes.  Vmem reserved: 12288K bytes.
   (slice1)    Executor memory: 8375K bytes avg x 3 workers, 8375K bytes max (seg0).
  Peak memory: 9488K bytes avg x 3 workers, 9488K bytes max (seg0).  Vmem reserved: 9216K bytes avg x 3 workers, 9216K bytes max (seg0).
 Total memory used across slices: 40247K  bytes
 Statement statistics:
   Memory used: 128000K bytes
```
Signed-off-by: NSambitesh Dash <sdash@pivotal.io>

* docs: create table- fixed default storage options information
default storage options can be set for system, database, user.

* Small edit to keep it in line with the 4.3.x commit.

Adding sha256 as an additional validation method since md5 is not
supported with FIPS mode enabled. Sha256 in the database requires
pgcrypto so we check if the source and destination system have pgcrypto
installed.
Signed-off-by: NChris Hajas <chajas@pivotal.io>

* resgroup: provide helper function to wakeup a proc.
* resgroup: provide helper function to check resWaiting.
* resgroup: refine the logic in ResGroupWaitCancel().
* resgroup: error out in ResGroupHashFind() directly.
* resgroup: error out in ResGroupHashRemove() directly.
* resgroup: add an arg `grant` in wakeupSlots().
* resgroup: move resWaiting updates into WaitQueue helper funcs.
* resgroup: cleanup the duplicate wakeup logic in ResGroupSlotRelease().
* resgroup: fix typo in function name groupAssignChunks().
* resgroup: rename groupAssignChunks() to groupRebalanceQuota().
* resgroup: polish comments for groupApplyMemCaps().
* resgroup: add comments for ResGroup{Caps,Opts}.
* resgroup: cleanup obsolete declarations in resgroup.h
* resgroup: use int32 instead of uint32 for self->memUsage.
* resgroup: correct the slot cleanup in ResGroupWaitCancel().
* resgroup: do not error out in transaction callbacks.

These tables seem dead and were only used before 4.0 era, hence removing them
now from catalog.

The runaway query TINC tests occasionally encounter issues where a
gpstop -ar is not successfull because of open connections. This commit
ensures that at the least gpstop will always restart gpdb.
Signed-off-by: NEkta Khanna <ekhanna@pivotal.io>

This reverts commit e449b1e0.

The NetBackup server has been failing in the first backup run after the
client is set up. We have not been able to discover the cause yet.
We are adding a dummy test where we don't check the return code so that
the rest of the tests will pass.
Signed-off-by: NChris Hajas <chajas@pivotal.io>

GPOS using GPDB for memory allocation is still a feature hidden behind a
GUC and requires more performance testing to be considered for the
default allocation behavior of GPOS. For now it can be ignored from
determing if a build of GPDB is release worthy

configure requires libcurl when pxf is enabled, it's not needed
for resource group regression tests, so disable it.

Previously every resource group has its own slot pool, each with size of 'MaxConnection'.
In order to reduce memory usage, implement a slot pool shared by all resource groups.

In addition, free slots in the slot pool are organized as a free list to optimize alloc/free
operations.

functions

In copyFuncs(), the fallthrough for SpecialJoinInfo was unintentionally
done as a part of subselect merge.  This commit fixes that along with
adding support for new fields in copyFuncs(), outFunc() and equalFunc()

[Ref #151491231]
Signed-off-by: NDhanashree Kashid <dkashid@pivotal.io>