ViewTube

Stored functions, procedures and triggers in PostgreSQL 16, measured on 100000 generated orders, and when that logic belongs ...

A catalogue of conditions that hide a column from its index, with the rewrite for each, measured on 240000 generated orders and ...

What PostgreSQL 16 does with a query before any plan exists, shown with real error messages and the character positions from ...

Your frontend can be rewritten. Your API can be rewritten. Your data is forever. In this video we open the box under every app ...

Query PostgreSQL directly from ClickHouse using SQL—without exporting CSV files or writing Python scripts. In this hands-on ...

WHERE filters rows before they are grouped; HAVING filters groups after the aggregates are computed. On real PostgreSQL 16 ...

The four ways PostgreSQL 16 can partition a table, each on generated data. Range: monthly partitions for 90000 events, inclusive ...

postgres #postgresql #tutorial #databases #string #translate #replace #length #function Queries at ...

Three planner rewrites you can see in PostgreSQL 16's EXPLAIN, on 200000 generated orders. Predicate pushdown through ...

Does it matter whether you write a subquery, a join or a CTE? On real PostgreSQL 16 plans over 20000 generated customers and ...

Part 1 of Domain 8 (Monitoring & Logging) of the OAPE PostgreSQL DBA-1 certification, 8 exam topics in one video: the session ...

How hashing works, with real hash values from PostgreSQL 16's internal hash functions. A hash function is deterministic, fixed ...

Compute cumulative metrics with ordered windows. On a real PostgreSQL 16 database with the module's sales table, ...

Reason about the sorts and partitions a window function requires, on real PostgreSQL 16 plans. On the module's 11-row sales ...

Seven of twenty-one items came back, and PostgreSQL says the return rate is 0. On the Module 8 dataset (m08_types) and real ...

Control which rows each window sees, and in what order. On a real PostgreSQL 16 database with the module's 11-row sales ...

Join tables that share no key. On a real PostgreSQL 16 database we match orders to the promotion running on their date with a ...

What a view really is to the PostgreSQL planner, when you can write through one, and how generated columns compare with ...

Six query rewrites that cut join, aggregate and sort work, measured in PostgreSQL 16 on 200000 generated transfers. An OR in a ...

Three end-to-end optimization case studies on PostgreSQL 16 with generated data, each taken through the same loop: symptom, ...