DBARefGPDBlib - Over 200 utility functions. Smarter way to manage and use Greenplum database. - Coming Soon!!!!! 

Greenplum DBA Quick Reference

  • Understanding GPDB BLOAT on heap, AO, AO Columnar tables by examples Understanding Greenplum Bloat by Examples    Step 1: Create heap, ao and ao columnar (column oriented) table drop table IF EXISTS sachi.vac_test_heap; drop table IF EXISTS sachi.vac ...
    Posted Apr 22, 2022, 3:08 PM by Sachchida Ojha
  • Fixing gp_bloat_diag view - showing bloated tables even there are no bloats on those tables Recently we found that gp_toolkit.gp_bloat_diag view shows some bloated tables which were recently reorg (vacuum full) and analyzed .Problem was due to incorrect data reported by ...
    Posted Aug 30, 2018, 11:12 AM by Sachchida Ojha
  • Dynamic UNIX script to change the owner of tables in Greenplum -- Change owner of all tables of a given schemafor tbl in `psql -qAt -c "select tablename from pg_tables where schemaname = 'public';" sachi` ; do  psql -c "alter table $tbl ...
    Posted Oct 26, 2014, 6:34 AM by Sachchida Ojha
  • Checking bloats with customized scripts gp_bloat_diag view helps to identify tables that need routine table maintenance (VACUUM and/or ANALYZE). See also : Creating a test case for bloat and understanding how it works ...
    Posted Oct 23, 2014, 6:08 PM by Sachchida Ojha
  • Sachi's SQL script collections for Greenplum DBA's SQL to list all parameter settings in GreenplumDCA Information -DCA software version, Database version, no of segments, space used/available on each segments, segment downtime report SQLSQL to ...
    Posted Nov 14, 2014, 3:28 PM by Sachchida Ojha
Showing posts 1 - 5 of 15. View more »
  • Public Yum Server The Oracle public yum server offers a free and convenient way to install the latest Oracle Linux packages as well as packages from the Oracle VM installation media via a ...
    Posted Apr 22, 2013, 8:43 AM by Sachchida Ojha
  • Oracle external table just like external table in Greenplum In the Greenplum database, we use external table combined with gpfdist to read the data from a  csv file located in in a directory and then then load that data ...
    Posted Feb 23, 2013, 5:08 PM by Sachchida Ojha
  • RESUMABLE SPACE ALLOCATION Oracle database provides a way to suspend long-running operations in the event of space allocation failure. Once the DBA is notified and space issue has been corrected, the long ...
    Posted Feb 4, 2012, 12:01 AM by Sachchida Ojha
Showing posts 1 - 3 of 19. View more »