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

Contact us about closed training

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