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.

SOUG (Swiss Oracle User Group) The members of the SOUG (Swiss Oracle User Group) benefit from a 5 % reduction.

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)

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 - book now!

You want to book a dbi InSite Workshop or get more information on our IT trainings? Please fill in the entry form below. We will confirm your participation or come back to you as soon as possible. If, to our regret, the workshop is already fully booked, we will inform you on other dates or alternative solutions.

Training sessions :




Please contact me via :  E-mail Phone

Where did you know dbi services ?



dbi InSite Workshop on-site - request & information

You want dbi services to hold an "on-site" workshop inside your organisation? 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-mail Phone

Where did you know dbi services ?