Env: PostgreSQL or Greenplum Symptom: COPY from a file into a table fails with error: ERROR: invalid byte sequence for encoding ...

Symptoms: Greenplum performance degrades and NIC overruns keep increasing. Root cause: large receive off load (LRO) and generic receiv...

Symptom: Below SQL can not finish after 5 hours and only 30% finished. insert into target select * from source; Both source table and ta...

Goal: Parse the SQL statement to get the SQL type from master log -- such as SELECT, UPDATE, COPY, DELETE, etc. You need to firstly creat...

Per Greenplum Admin Guide: "The coefficient of variation (CV) is calculated as the standard deviation divided by the average.". T...

In Greenplum, if there are more than 128(including 128) DML transactions on one AO(AppendOnly) table, some transactions may fail with "...

This article shows some deep dive troubleshooting using gdb for Greenplum. 1. Print the waiting lock for "LWLockAcquire" p *loc...

Greenplum SQL plan checker (Note: This link is dead because I shutdown the webserver)is a web tool created by me to auto-analyze Greenplum ...

Greenplum is MPP architecture, and sometimes it utilizes ssh sessions to complete some tasks. For large clusters, MaxStartups in /etc/ssh/...

Before running gpcheckcat, in maintenance window, run below scripts to check if Greenplum has orphan temp schema on master or segments. The...

Question:  Could We load windows characters such as ^M(ctrl-V-M) and $(end of line) to Greenplum database using gpload? Below is an exam...

Below Greenplum SQLs can help author troubleshoot issues, that is why they are here. 1. Master/Segment logs => Table CREATE EXTERNAL W...

Wanna send emails using a function in Greenplum? Here you are. 1. Start sendmail service /etc/rc.d/init.d/sendmail start 2. Configure ...

Greenplum Database has native support for SSL connections between the client and the master server. SSL connections prevent third parties f...