Databases & SQL · PostgreSQL

PostgreSQL Tutorial

SQL ergonomics through EXPLAIN intuition, transactional behaviour, pragmatic schema design.

Start tutorial

Sponsored

Lesson outline

  1. 109
    Adjust Autovacuum Safely

    Learn to adjust PostgreSQL autovacuum settings without risking performance or bloat. Explore key parameters, safe tuning practices, and a hands-on exercise to apply changes confidently.

  2. 110
    Monitor Queries with pg_stat_statements

    Learn how to monitor PostgreSQL queries using pg_stat_statements — a practical lesson for identifying performance bottlenecks.

  3. 111
    Track Database Size and Bloat

    Track database size and bloat in PostgreSQL to reclaim storage and boost performance. This lesson explains why bloat happens, how to measure it with pg_stat_user_tables and pgstattuple, and how to interpret the numbers. You'll run queries to identify bloated tables and indexes, then learn when to VACUUM, REINDEX, or pg

  4. 112
    Use pg_stat_activity for Live Checks

    Learn to use pg_stat_activity to monitor live queries, connections, and locks—and troubleshooting tips for real-world scenarios.

  5. 113
    Create partitioned tables by range

    Create partitioned tables by range — PostgreSQL Tutorial. Learn the core concept, step-by-step implementation, practical exercise, and troubleshooting tips.

  6. 114
    List Partitioning by Category

    Use list partitioning for categories in PostgreSQL to improve query performance and manageability. Step-by-step instructions, examples, and troubleshooting tips.

  7. 115
    Manage Partition Pruning

    Master PostgreSQL partition pruning and index management: when pruning kicks in, common pitfalls, and how indexes interact with partitioned tables to keep queries fast.

  8. 116
    Lock Contention Handling

    Handle lock contention gracefully in PostgreSQL — practical steps to avoid deadlocks, timeouts, and blocked queries.

  9. 117
    Avoid Deadlocks with Consistent Ordering

    Learn how to prevent deadlocks in PostgreSQL by locking rows in a consistent order — a key skill for robust concurrent transactions.

  10. 118
    Use Advisory Locks

    Use advisory locks for coordination — PostgreSQL Tutorial. Learn how to coordinate distributed processes with PostgreSQL advisory locks.

  11. 119
    PL/pgSQL Stored Procedures

    Write stored procedures with PL/pgSQL in this PostgreSQL tutorial. Learn the core concepts, step-by-step syntax, and best practices for creating reusable procedures. Includes hands-on exercises and troubleshooting tips to solidify your skills.

  12. 120
    Create Triggers with Functions

    Create triggers with trigger functions—PostgreSQL Tutorial. Learn the core concept, step-by-step implementation, and practical examples to automate database actions.

    PostgreSQL Tutorial — step-by-step tutorials

    What you will find here

    This track walks through postgresql tutorial in order — each lesson is server-rendered HTML you can read without JavaScript. Follow the outline, then practice in the browser IDE when a lesson links to runnable code.

    Tutorials vs quizzes and code samples

    Tutorials teach in sequence. For quick checks use quizzes. For copy-paste snippets see code samples. For deeper reading browse articles.