PostgreSQL DBA Table Partitioning and PG_UPGRADE

Certified PostgreSQL DBA Certification (CPSDBA) – Module 8 – This Module is also part of PostgreSQL DBA Certification

Only Vendor Neutral Training & Certification course for PostgreSQL DBA

What you’ll learn

  • Table Partitioning.
  • Partitioning Methods.
  • Use of Partitioning.

Course Content

  • Table Partitioning –> 3 lectures • 31min.
  • Tablespaces –> 5 lectures • 23min.
  • PG_UPGRADE –> 1 lecture • 15min.

Auto Draft


Only Vendor Neutral Training & Certification course for PostgreSQL DBA


PostgreSQL is a powerful, open source object-relational database system that uses and extends the SQL language combined with many features that safely store and scale the most complicated data workloads. The origins of PostgreSQL date back to 1986 as part of the Postgres project at the University of California at Berkeley and has more than 30 years of active development on the core platform.

PostgreSQLCert is a dedicated PostgreSQL Training, Certification & Services division of CertFirst (A leading Global Open Source and Security certification Training Provider). CertFirst became the first company in 2005 to launch a structured PostgreSQL Training & Certification program and has successfully provided hands-on Instructor-led training to hundreds of clients world-wide.

Postgresqlcert offers vendor Neutral certification programs so the client can get to learn about all available options in the market NOT just focused on one vendor who is just trying to promote their own products and services. Postgresqlcert goal is provide the best possible non-bias training & certification possible to all its clients.



  • Basic SQL & Linux OS
  • Internet access is required to download PostgreSQL Server
  • Basic understanding of SQL language is highly recommended but not required

Target Audience:

Existing Oracle, MySQL or Microsoft DBA’s or new candidates interested in getting certified as a PostgreSQL DBA.

Certification Exam Fee: $195 (not Included)

This extensive PostgreSQL DBA training & certification program is divided in to several domains. Each video covers a specific specialized topic which will enable candidate to master each domain by learning and then applying this knowledge in the hands-on environment. Local or cloud installation will be required in order to perform all labs.


The PostgreSQLCert module focusing on “PostgreSQL DBA table partitioning and PG_UPGRADE” provides comprehensive coverage of two critical aspects of PostgreSQL database administration. Firstly, it explores table partitioning, an effective technique utilized to enhance database performance and streamline the management of large datasets by partitioning tables into smaller, more manageable segments based on defined criteria such as ranges or hash values. The module extensively discusses various partitioning strategies, implementation approaches, and recommended practices aimed at optimizing performance and simplifying data administration.

Secondly, the module delves into PG_UPGRADE, a utility within PostgreSQL designed to facilitate the seamless upgrade of database clusters to newer versions while ensuring data integrity and minimizing downtime. It encompasses detailed guidance on the entire upgrade process, from initial planning and preparatory steps to executing the upgrade and conducting post-upgrade verification and testing. Additionally, this module serves as valuable preparation for the PostgreSQL DBA certification program, equipping participants with the necessary knowledge and skills to excel in their certification journey.