Greenplum DBA FAQ

Finding Bad table name in Greenplum - May 27, 2022 6:58:5 PM

MADLib and MADLib pivot function - Oct 06, 2016 7:25:1 PM

Enable PQO for a specific user/role - Jan 15, 2016 3:19:22 AM

New Parameters in GPDB 4.3 and onward - May 27, 2015 11:13:56 PM

Out of Memory error in Greenplum? - Jan 04, 2015 3:5:22 PM

Finding Syntax of a PSQL command - Dec 03, 2014 8:6:3 PM

pg_default resource queue - Dec 03, 2014 2:15:4 AM

Understanding Query iterator - Nov 17, 2014 1:8:52 AM

Oracle rownum in Greenplum - Nov 11, 2014 11:48:49 PM

Table row counts - Oct 20, 2014 12:0:40 AM

GP functions in pg_catalog schema - Oct 19, 2014 6:33:33 PM

Partition Information - Oct 18, 2014 12:34:41 AM

Date Difference Ffunction - Oct 17, 2014 11:49:21 PM

Finding partition keys in Greenplum - Oct 12, 2014 9:20:28 PM

Finding distribution key of a table - Oct 12, 2014 8:49:12 PM

List of tables altered in last 10 days - Oct 12, 2014 8:10:59 PM

List of table created in last 30 days - Oct 12, 2014 8:10:9 PM

Exploring pg_stat_last_operation - Oct 12, 2014 7:51:24 PM

pg_stat_resqueues - Oct 12, 2014 3:5:58 AM

How data is stored in Greenplum - Oct 12, 2014 2:52:19 AM

Fixing size bloat in Greenplum tables - Sep 11, 2014 2:46:21 AM

Important gp_% tables and views - Sep 03, 2014 12:31:33 AM

Fault Detection and Recovery - Mar 14, 2014 1:52:16 AM

Vacuuming an append-optimized table - Mar 14, 2014 12:53:2 AM

3 ways to backup Greenplum database - Feb 02, 2014 10:0:11 PM

Query execution process is greenplum - Nov 26, 2013 8:11:2 PM

How do I install pgcrypto? - Nov 20, 2013 7:48:22 PM

How to recover a failed segment - Nov 18, 2013 2:52:22 AM

How to check failed Segments - Nov 18, 2013 2:18:26 AM

Slow disk performance with dcaperfcheck - Nov 18, 2013 1:57:14 AM

DCA_SETUP utility - Nov 17, 2013 4:18:24 PM

PERC and PERC learn cycle - Nov 17, 2013 3:57:58 PM

Parameter Setting Precedence. - Nov 16, 2013 4:17:34 PM

VIP Monitoring - Oct 17, 2013 6:35:43 PM

DR Options in Greenplum Env - Oct 17, 2013 5:28:37 PM

Size of partitioned table - Oct 17, 2013 5:18:0 PM

Comparing Greenplum schema - Oct 17, 2013 2:42:28 PM

GP license audit - Sep 13, 2013 12:36:17 PM

SNMP Version 1, 2c and 3 - Aug 30, 2013 1:4:29 PM

rpm's for DCA v2 - May 07, 2013 5:52:14 PM

PSQL exit status - May 02, 2013 3:15:45 PM

Viewing partitions in greenplum - May 02, 2013 2:6:46 PM

Schema search path - Apr 17, 2013 5:7:3 PM

Web External Tables - Apr 16, 2013 10:29:48 PM

Viewing Users and Groups (Roles) - Apr 12, 2013 3:35:32 PM

Grant user priv to access schema - Apr 12, 2013 2:25:54 PM

Show all grants - Dec 11, 2012 5:6:23 PM

tablespace in Greenplum database - Dec 06, 2012 7:54:4 PM

Duplicate rows in pg_partition_columns - Dec 05, 2012 12:36:18 PM

LDAP Security - Nov 29, 2012 8:57:33 PM

DCA failover - Nov 29, 2012 5:49:27 PM

What is "gang" in greenplum - Nov 08, 2012 7:50:49 PM

How to backup database in Greenplum? - Nov 07, 2012 9:30:45 PM

Date/Time Functions and Operators - Oct 26, 2012 4:52:43 PM

MONITORING DISK SPACE in Greenplum - Oct 09, 2012 8:36:13 PM

GREENPLUM AND  SNMP - Oct 09, 2012 8:30:58 PM

What is GUC in Greenplum - Oct 09, 2012 8:3:14 PM

What's new in greenplum database 4.2.2 - Oct 09, 2012 6:27:59 PM

Monitoring Greenplum database log files - Oct 09, 2012 6:21:31 PM

How to fix gpssh when it is hanging? - Oct 05, 2012 10:56:19 PM