Infrastructure at your Service

PostgreSQL Performance Tuning workshop

dbi InSite Workshops

PostgreSQL performance tuning is a broad subject with many questions looking for answers: How should I configure my PostgreSQL instance, which PostgreSQL indexes do I need to create, and which are the best tools to monitor the performance of the PostgreSQL instance? The dbi services PostgreSQL performance tuning experts will share their knowledge, methods, and tools with you in our two-day dbi InSite workshop “PostgreSQL Performance Tuning”. Through various practical exercises and live demos, you will understand how the PostgreSQL Optimizer works and learn how to make the best out of it.

Training’s dates

2 days
CHF 1800.- *

Trainers

  • Daniel Westermann
    Daniel Westermann
  • HervĂ© Schweitzer
    Hervé Schweitzer

By booking a dbi services’ InSite workshop, the customer commits to respecting the Sales and Service General Conditions

(*) Prices are to be considered per participant and without VAT

-5% for SOUG, SwissPUG, or DOAG members
Members of the SOUG (Swiss Oracle User Group), SwissPUG (Swiss PostgreSQL User Group) or DOAG (Deutsche Oracle-Anwendergruppe) are entitled to a discount of 5% on our trainings

Training objectives

  • Understand how PostgreSQL uses the system resources (CPU, I/O, Memory) and configure them
  • Learn how the Cost Based Optimizer optimizes the access to your data
  • Know everything about execution plan operations (sequental scans, index access, sorts, etc.)
  • Monitor the performance with standard PostgreSQL tools and extensions
  • Learn the tuning of queries via features available to the developer and/or DBA
  • Understand the PostgreSQL index types
  • Using stored procedures

Topics

  • Memory Sizing: shared_buffers, work_mem, …
  • I/O calls performed by PostgreSQL
  • CBO, cardinality, cost, optimization, execution plan, parameters
  • Statistics
  • Sequential scans and indexing
  • Sorts and Group By
  • Join methods
  • pg_stat_statements, pg_buffercache
  • Connection handling
  • Transaction isolation levels
  • Performance relevant logging parameters

Method

  • Presentation with countless practical exercises and trainings
  • Case studies, live demos, discussions
  • Networking during coffee break, lunch, and apĂ©ro on last day (included in price, except for on-site workshop courses)
  • Graphical tool courtesy of DB Visualizer

Target groups

  • Database administrators (DBAs) wanting to improve the system performance, Database developers wanting to improve the application performance

Language & documentation

  • Workshop training normally held in English; French or German possible instead as course languages
  • Documentation: content details, scripts, case study solutions as PDF file (in English)

For your information

    dbi InSite Workshop on-site - request & information

    You want dbi services to hold an "on-site" (in your premises) workshop for you ? You have special requirements, e. g. regarding the content, the duration, the date, or the number of participants?
    We have good news for you: Our dbi InSite Workshops can be flexibly adapted to your needs! Please just fill in the form below and we will come back to you as soon as possible. You may also use this form to inquire on the future dates of our dbi InSite Workshops.





    Please contact me via :

    E-mailPhone

    Where did you know dbi services ?