dropuser Synopsis Description Arguments Options Examples dropuser Removes a database role. Synopsis dropuser [< connection_options >] [- e | -- echo ] [- i | ...

PREPARE Synopsis Description Parameters Notes Examples Compatibility See Also PREPARE Prepare a statement for execution. Synopsis PREPARE <name> [ (< datatype > ...

CREATE FUNCTION Synopsis Description Parameters Notes Examples Compatibility See Also CREATE FUNCTION Defines a new function. Synopsis CREATE [ OR REPLACE ] FUNCTIO...

Troubleshooting PXF PXF Errors PXF Logging Service-Level Logging Database-Level Logging Addressing PXF Memory Issues Increasing the Maximum Heap Size Decreasing the Maximum Nu...

CHECKPOINT Synopsis Description Compatibility CHECKPOINT Forces a transaction log checkpoint. Synopsis CHECKPOINT Description Write-Ahead Logging (WAL) puts a checkp...

SET ROLE Synopsis Description Parameters Notes Examples Compatibility See Also SET ROLE Sets the current role identifier of the current session. Synopsis SET [ SESSI...

Query Profiling Reading EXPLAIN Output EXPLAIN Example Reading EXPLAIN ANALYZE Output EXPLAIN ANALYZE Example Examining Query Plans to Solve Problems Generating EXPLAIN Plan f...

Using MADLib with Ranger Authorization Using MADLib with Ranger Authorization You can use MADlib, an open source library for in-database analytics, with your HAWQ installation....

Basic Data Operations Inserting Rows Vacuuming the System Catalog Tables Configuring the Free Space Map Basic Data Operations This topic describes basic data operations that...

gp_segment_configuration gp_segment_configuration The gp_segment_configuration table contains information about master, standby and segment configuration. The HAWQ fault tole...