Increasing PostgreSQL query performance

SPEED IT UP

Increasing PostgreSQL query performance

Training description

 

This training covers various topics related to PostgreSQL query optimisation.

Duration: 2 days 8 hours each (including an hour lunch break)

Requirements: At least basic knowledge of SQL and at least minimum experience with PostgreSQL. Those can be acquired during our training “SQL for beginners”.

Training agenda

Part one: I’ve been waiting for so long…

  • Why is my query slow
  • Execution order

Part two: Analyzing the query

  • EXPLAIN
  • ANALYZE

Part three: Column indexing

  • Index types
  • Partial indexing
  • Indexing results of a function
  • Indexing text to quickly search later

Part four: Optimizing queries

  • Aggregates optimization
  • HashAggregates vs. GroupAggregates
  • DISTINCT vs. GROUP BY
  • Optimizing IN statements
  • Optimizing ORDER BY statements
  • JOIN order and its influence on performance
  • Optimizing SET statements

Upcoming open trainings

Currently, no open training covering the given issue is planned. We encourage you to contact us regarding the closed training.

Contact us about closed training
Go to open training base

This website uses cookies to ensure you get the best experience on our website.
Ok, got it. More about cookies