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 ...

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

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

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

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

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

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

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

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

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

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

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

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

Turn many rows into one answer. On real PostgreSQL 16 we total a month of orders with SUM, compute AVG, MIN and MAX in ...

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

Compare each row with its neighbours using LAG and LEAD. On a real PostgreSQL 16 database with the module's sales table, ...

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

This guide demonstrates how to use PostgreSQL functions to: Aggregate data quarterly Calculate percentage change ...

Test whether a matching row exists, correctly and cheaply. On a real PostgreSQL 16 database we see EXISTS return true or false ...