Greenplum DBA FAQ
Finding Bad table name in Greenplum - May 27, 2022 6:58:5 PM
Understanding Greenplum Bloat on heap, AO and AO columnar tables by examples and how to remove it. - Apr 22, 2022 10:14:59 PM
MADLib and MADLib pivot function - Oct 06, 2016 7:25:1 PM
Checking list of security definer functions in GPDB - May 11, 2016 11:55:56 AM
Connecting as another user without their password - Jan 15, 2016 8:41:29 AM
Enable PQO for a specific user/role - Jan 15, 2016 3:19:22 AM
Enable PQO (Pivotal Query Optimizer) at the database level - Jan 15, 2016 1:53:5 AM
Select runs but insert failing in Greenplum database - Jun 13, 2015 3:23:30 PM
New Parameters in GPDB 4.3 and onward - May 27, 2015 11:13:56 PM
List Append Only / Append Organized table details in Greenplum - May 27, 2015 10:12:34 PM
Spill or workfile configuration parameters - May 25, 2015 4:17:53 PM
Summary Of New Features in Greenplum Database 4.3.X.X - May 24, 2015 1:24:57 PM
Copy table and data from dev (half DCA rac) to test env (full DCA rac) with copy - Feb 26, 2015 7:53:4 PM
Making a duplicate copy of a schema in the same database without data in Greenplum - Feb 26, 2015 7:14:1 PM
pg_stat_activity not showing current_query text - Feb 26, 2015 5:8:26 PM
SQL query to list group role along with its members - Jan 28, 2015 3:16:52 PM
Troubleshooting BOE connection error to GPDB using Data direct driver after SSL is turned on on GPDB - Jan 23, 2015 4:6:17 AM
4 parameters used to configure and monitor disk space alerts using emc call home feature - Jan 21, 2015 9:27:5 PM
Two important connection parameters for Greenplum DBA's - Jan 21, 2015 1:19:27 PM
ERROR: Function cannot execute on segment because it accesses ... - Jan 15, 2015 4:0:38 PM
Out of Memory error in Greenplum? - Jan 04, 2015 3:5:22 PM
What should an application do if they get an “out of memory” error? - Jan 04, 2015 2:55:14 PM
Data types to be used and avoid in a distribution in Greenplum - Dec 04, 2014 11:8:35 PM
Finding Syntax of a PSQL command - Dec 03, 2014 8:6:3 PM
Finding table creation time in Greenplum - Dec 03, 2014 6:8:45 PM
Understanding default values of general configuration parameters related to resource queue - Dec 03, 2014 2:41:32 AM
pg_default resource queue - Dec 03, 2014 2:15:4 AM
NaN - Not a Numeric or Not a Number error in Greenplum - Nov 17, 2014 6:44:0 PM
Understanding Query iterator - Nov 17, 2014 1:8:52 AM
OFFSET, LIMIT and ROW_NUMBER() OVER() in GREENPLUM - Nov 16, 2014 4:42:56 PM
Enable and disable indexes in Greenplum like oracle - Nov 12, 2014 3:37:51 PM
Oracle rownum in Greenplum - Nov 11, 2014 11:48:49 PM
List all tables in your database - largest first - largest in terms of no or row or tuples - Nov 11, 2014 1:32:29 AM
List all tables in your database - largest first - largest by no of relpages - Nov 11, 2014 1:22:38 AM
Log related views in the gp_toolkit schema - Nov 05, 2014 11:8:24 PM
How to find last ALTAR TABLE DDL on a table in Greenplum - Nov 04, 2014 10:1:57 PM
A simple shell script to redistribute, index and analyze table in Greenplum - Nov 01, 2014 3:57:51 PM
Users, Group roles, Group role user mapping, priv granted to a role etc - Oct 30, 2014 4:59:27 PM
Get DDL for all schema in your database in Greenplum - Oct 30, 2014 12:14:46 PM
Handling schema names starting with numeric during maintenance operation - Oct 23, 2014 12:9:30 AM
List of GP configuration parameters supported by gpconfig - Oct 20, 2014 1:31:40 AM
Changing Greenplum configuration parameter using gpconfig - Oct 20, 2014 12:25:39 AM
Table row counts - Oct 20, 2014 12:0:40 AM
Retrieving information about tables and views - Oct 19, 2014 10:14:12 PM
GP functions in pg_catalog schema - Oct 19, 2014 6:33:33 PM
List no of columns in a table in Greenplum - Oct 19, 2014 6:22:14 PM
Greenplum database ASH (active session history) Report - Oct 19, 2014 5:46:32 PM
Greenplum database (GPDB) AWR report light and advanced version - Oct 18, 2014 4:6:1 PM
Partition Information - Oct 18, 2014 12:34:41 AM
Worst Performing SQL (taking more than 30 minutes) in Greenplum in last 2 days - Oct 18, 2014 12:9:44 AM
Date Difference Ffunction - Oct 17, 2014 11:49:21 PM
Table and index size (including partitioned tables) - Oct 16, 2014 7:1:7 PM
Creating a test case for bloat and understanding how it works in Greenplum - Oct 16, 2014 3:21:31 PM
Greenplum catalog partition tables, views and functions - Oct 12, 2014 9:59:51 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 not vacuumed in last 3 days - Oct 12, 2014 8:11:36 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
List of tables not analyzed in last 3 days - Oct 12, 2014 8:9:36 PM
Exploring pg_stat_last_operation - Oct 12, 2014 7:51:24 PM
Greenplum database resource queues - way to limit available resources to database users - Oct 12, 2014 12:56:32 PM
pg_stat_resqueues - Oct 12, 2014 3:5:58 AM
How to find resource queue parameter settings? - Oct 12, 2014 2:54:11 AM
How data is stored in Greenplum - Oct 12, 2014 2:52:19 AM
Gpfdist session is dying while running multiple gpload session from Informatica - Oct 10, 2014 5:0:31 PM
Using SNMP with a Greenplum Database System - Oct 10, 2014 12:14:17 AM
Information about Greenplum Schema, Tables and Columns - Sep 25, 2014 1:9:0 AM
How to move a table from one schema to another schema - Sep 24, 2014 6:17:13 PM
How to check table creation time in Greenplum - Sep 19, 2014 3:4:49 PM
Checking physical file associated with a table - Sep 11, 2014 3:25:13 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
SQL to review distribution across all segments - Aug 23, 2014 4:25:49 PM
Database, schema, and table sizes in Greenplum - Aug 19, 2014 7:27:47 PM
Monitoring distribution keys in Greenplum - Jul 25, 2014 12:16:35 PM
Finding distribution keys of all greenplum database tables - Jul 25, 2014 12:11:36 PM
How to get a timestamp of when a user last accessed any Greenplum data - May 05, 2014 7:11:42 PM
Activating standby master when primary master goes down - Mar 14, 2014 2:4:9 AM
Fault Detection and Recovery - Mar 14, 2014 1:52:16 AM
Sample script to performs a VACUUM of the Greenplum Database system catalog - Mar 14, 2014 12:56:18 AM
Vacuuming an append-optimized table - Mar 14, 2014 12:53:2 AM
How to run a command in all the segment simultaneously - Feb 06, 2014 12:26:24 AM
How to check interconnect performance in Greenplum Appliance - Feb 06, 2014 12:17:34 AM
How to boost database backup performance - Feb 02, 2014 10:7:2 PM
3 ways to backup Greenplum database - Feb 02, 2014 10:0:11 PM
Greenplum Database Parallel Backup and Restore Operations - Few Facts - Feb 02, 2014 9:51:41 PM
Non-Parallel Backup Support in Greenplum - Feb 02, 2014 9:44:6 PM
Greenplum Database Management Utility Log Files - Feb 02, 2014 9:13:18 PM
Append-Optimized Tables - New Feature in Greenplum V3.0 - Jan 21, 2014 7:54:1 PM
Using gp_toolkit schema view to check Failed Segments - Jan 21, 2014 3:23:45 PM
Resource Queue activity and status check using gp_toolkit schema views - Jan 21, 2014 3:14:16 PM
How to debug bad performing queries due to uneven data distribution - Jan 21, 2014 3:54:54 AM
Checking Database Object Sizes and Disk Space in Greenplum using gp_toolkit schema views - Jan 21, 2014 2:20:39 AM
gp toolkit schema views to view Greenplum database server log files - Jan 20, 2014 9:44:20 PM
gp toolkit views to diagnose queries and sessions that are waiting to access an object due to a lock - Jan 20, 2014 8:46:14 PM
Checking for Tables that Need Routine Maintenance - Jan 20, 2014 4:4:44 PM
Listing table size of all schema tables. - Dec 12, 2013 5:15:24 PM
SQL to display percent free space in Greenplum - Dec 09, 2013 3:1:15 PM
HOW TO CREATE RESOURCE QUEUE IN GREENPLUM - Nov 28, 2013 4:30:39 PM
Linux 6.1 public key authentication issue - Nov 27, 2013 9:17:27 PM
gpssh-exkeys -h hostname issues when installing greenplum - Nov 27, 2013 8:11:49 PM
Best practice for creating indexes in greenplum - Nov 27, 2013 2:47:40 AM
Limitations of Partitioned Tables on Greenplum Database - Nov 27, 2013 2:33:7 AM
Altering a table storage, distribution policy in Greenplum - Nov 27, 2013 2:29:10 AM
What are different types of storage model for Greenplum database tables? - Nov 27, 2013 2:15:53 AM
Most common connectivity issues with Greenplum database - Nov 26, 2013 8:43:12 PM
Third party client tools supported by Greenplum - Nov 26, 2013 8:36:56 PM
How to limit Concurrent Connections in Greenplum - Nov 26, 2013 8:25:13 PM
Query execution process is greenplum - Nov 26, 2013 8:11:2 PM
What are immutable, stable and volatile functions in greenplum - Nov 26, 2013 6:55:25 PM
How do I install pgcrypto? - Nov 20, 2013 7:48:22 PM
How to backup a table/set of tables in greenplum - Nov 18, 2013 3:12:5 AM
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
Finding the status of running greenplum database system - Nov 18, 2013 1:13:41 AM
Incremental Backup in Greenplum Database - Nov 17, 2013 4:36:24 PM
DCA_SETUP utility - Nov 17, 2013 4:18:24 PM
How to upgrade PERC firmware, server BIOS and OMSA - Nov 17, 2013 4:14:10 PM
PERC and PERC learn cycle - Nov 17, 2013 3:57:58 PM
Parameter Setting Precedence. - Nov 16, 2013 4:17:34 PM
Incorrect results in restores of data from a backup using gpdbrestore and gp_restore utilities - Nov 06, 2013 6:37:38 PM
How to enable use of Oracle databases in Greenplum chorus - Oct 31, 2013 7:33:26 PM
How to Identify the version of the installed DCA software - Oct 31, 2013 1:7:6 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
Difference between CSV and TEXT formats used in external table definitions - Oct 17, 2013 5:3:6 PM
How to assign lowest priority to any long-running query - Oct 17, 2013 2:47:11 PM
Comparing Greenplum schema - Oct 17, 2013 2:42:28 PM
List of system-level schemas in Greenplum - Oct 11, 2013 7:0:22 PM
GP license audit - Sep 13, 2013 12:36:17 PM
How to change gpadmin unix user account password in Greenplum DCA env - Sep 12, 2013 5:55:53 PM
SNMP Version 1, 2c and 3 - Aug 30, 2013 1:4:29 PM
Save PSQL query output to CSV file in Greenplum - Jun 05, 2013 8:32:55 AM
How to clean up table in all segments created by an aborted transactions - May 30, 2013 5:8:59 PM
rpm's for DCA v2 - May 07, 2013 5:52:14 PM
Testing gpload utility in greenplum SNE env - May 03, 2013 9:37:46 PM
PSQL exit status - May 02, 2013 3:15:45 PM
Gathering Information for Greenplum Support - May 02, 2013 2:54:42 PM
Workload configuration parameters in greenplum - May 02, 2013 2:45:17 PM
Command based and URL based web external tables example - May 02, 2013 2:20:47 PM
Viewing partitions in greenplum - May 02, 2013 2:6:46 PM
Changing the table distribution policy in Greenplum - May 02, 2013 2:4:27 PM
Viewing current user, current schema and search path in greenplum - May 02, 2013 2:0:18 PM
viewing tablespace and filespace information in greenplum - May 02, 2013 1:52:37 PM
Generate Scripts to grant DML priv to other user or role - May 02, 2013 1:31:55 AM
Greenplum database development and administration tools - Apr 29, 2013 8:39:52 PM
Changing the value of a Greenplum Database configuration parameter using "set" command - Apr 29, 2013 12:26:2 PM
ERROR: permission denied: no privilege to create a readable gpfdist(s) external table - Apr 29, 2013 2:6:6 AM
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
INVOKER and DEFINER rights of PGSQL function - Apr 11, 2013 11:1:49 PM
How to find table creation/access time in Greenplum - Dec 21, 2012 12:34:17 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
How to Check the DCA software version and Check the Greenplum Database version - Nov 27, 2012 7:25:23 PM
What is "gang" in greenplum - Nov 08, 2012 7:50:49 PM
How to kill all idle connections in Greenplum database cluster - Nov 08, 2012 5:41:2 PM
How to backup database in Greenplum? - Nov 07, 2012 9:30:45 PM
How to identify distribution keys when moving from Oracle to Greenplum - Nov 06, 2012 7:17:24 PM
How to alter table distribution policy in greenplum? - Nov 02, 2012 11:25:17 PM
What is the Default Compression Values in Greenplum - Nov 02, 2012 11:23:18 PM
What is Run-length Encoding in Greenplum? - Nov 02, 2012 11:19:23 PM
How to Check the Compression and Distribution of an Append-Only Table - Nov 02, 2012 11:15:32 PM
What are the Table Distribution Policy in Greenplum - Nov 02, 2012 11:1:37 PM
Concurrency Control in Greenplum Database - Nov 02, 2012 4:51:24 PM
Date/Time Functions and Operators - Oct 26, 2012 4:52:43 PM
How to find dependent views created on any table in Greenplum database - Oct 16, 2012 4:59:55 PM
Checking stats of the Greenplum database - Oct 11, 2012 2:54:23 AM
List of tables in the GPPERFMON database - Oct 11, 2012 2:31:6 AM
Displaying information from PSQL command prompt - Oct 11, 2012 2:26:43 AM
How to find active and historical SQL queries in Greenplum database - Oct 11, 2012 2:1:51 AM
gpstart command fails to start the Greenplum Database - Oct 10, 2012 2:43:56 PM
MONITORING DISK SPACE in Greenplum - Oct 09, 2012 8:36:13 PM
AVOIDING DOUBLE FAULTS in Greenplum Database - Oct 09, 2012 8:33:43 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
Investigating and Preventing Performance issues in Greenplum - Oct 09, 2012 6:15:13 PM
How to collect logs for the Greenplum DCA Product - Oct 09, 2012 5:41:25 PM
How to collect information on hung Greenplum Database processes - Oct 09, 2012 5:33:52 PM
How to setup EMC Connect on the Greenplum Data Computing Appliance (DCA) - Oct 09, 2012 5:29:29 PM
What to do when gpperfmon GUI shows incorrect results in the current queries running - Oct 05, 2012 11:3:52 PM
How to Configuring SNMP events on a Greenplum DCA - Oct 05, 2012 11:0:19 PM
What are the recommended ODBC parameters for Greenplum? - Oct 05, 2012 10:57:42 PM
How to fix gpssh when it is hanging? - Oct 05, 2012 10:56:19 PM
Tips for supporting Greenplum on the Linux OS - Oct 05, 2012 10:54:13 PM
How to modify Global User Configuration (GUC) values in a Greenplum cluster - Oct 05, 2012 10:52:2 PM
How to troubleshoot Greenplum file distribution program (gpfdist) issues - Oct 05, 2012 10:48:49 PM
How to fix function based index that is not working in Greenplum - Oct 05, 2012 10:29:39 PM
Upon running gpstart, the start process fails with an unknown error. - Oct 05, 2012 3:11:48 PM
How to add an unsupported time zone to the Greenplum Database? - Oct 05, 2012 3:5:27 PM
How to view Data Distribution across segment Servers? - Oct 05, 2012 2:48:24 PM
How to script utility mode commands on all segments? - Oct 05, 2012 2:46:34 PM
How do I remove a segment node from Greenplum cluster while database is up and running? - Oct 05, 2012 2:22:39 PM
How to understand the segment mode and status of gp_segment_configuration table - Oct 05, 2012 2:16:9 PM
How to update catalog table in maintenance mode in Greenplum Database 4.2 - Oct 05, 2012 2:11:11 PM
How To reproduce the build configuration of the current Greenplum Database installation - Oct 04, 2012 8:5:54 PM
Greenplum 4.2.1.0 super user permission issue - Oct 04, 2012 5:8:41 PM
ERROR: permission denied: "gp_segment_configuration" is a system catalog - Oct 04, 2012 5:4:16 PM