Magnus Hagander
where else to find them
website:https://blog.hagander.net/
github:mhagander
bluesky:magnus.hagander.net
mastodon:@magnushagander@fosstodon.org
what they talk about
all 5 in the filters
where they keep going back
- foss-north3 editions2017–2026
- PostgresOpen2 editions2013–2014
- PGConf NYC2 editions2021–2022
all 10 in the filters
on a stage with
never shared a talk
who talks about the same things
- Bruce Momjian52 talks
- Will Leinweber13 talks
- Robert Treat10 talks
- Jonathan S. Katz18 talks
- Lætitia Avrot18 talks
- Simon Riggs19 talks
| title | conference | date |
|---|---|---|
| PostgreSQL Don'ts and Dos | foss-north 2026 | 2026-04-27 |
If backups take 48 hours with pg_dump expect a 5–6 day restore; switch to binary backups like pg_basebackup and a PITR-capable tool such as pg_backrest… | ||
| postgresql.org: The hidden parts | PGConf.dev 2025 | 2025-05-13 |
Volunteer-run PGInfra of seven people runs git.postgresql.org with a hidden master, the canonical downloads and apt/yum repos, 67 VMs across multiple… | ||
| A look at the Elephants Trunk - PostgreSQL 15 | PGConf NYC 2022 | 2022-09-22 |
PostgreSQL 15 is at release-candidate stage with five commit fests behind it and a release expected within weeks; key changes include dropping PL/Python2… | ||
| PostgreSQL—more relevant than ever | Citus Con: An Event for Postgres 2022 | 2022-04-12 |
PostgreSQL proves relevance with concrete wins: a permissive license that lets vendors and users redistribute and embed it, wide adoption like three Azure… | ||
| A look at the Elephants Trunk: PostgreSQL 14 | PGConf NYC 2021 | 2021-12-02 |
PostgreSQL 14 ships (released 2021-09-30) with concrete changes: scram-sha-256 default (breaks very old clients), SSL compression removal, and… | ||
| A Look at the Elephant's Trunk PostgreSQL 13 | Percona Live Online 2020 | 2020-10-20 |
PostgreSQL 13 lists concrete, deployable changes: drop database with force actually disconnects clients, autovacuum now triggers on inserts and can run index… | ||
| PostgreSQL gotchas for app developers | foss-north 2019 | 2019-04-07 |
Covers concrete PostgreSQL pitfalls: connection pools multiplying into 5,000 connections and why pools are often too large; never grant superuser to the app… | ||
| A look at the elephant's trunk - PostgreSQL 10 | PostgresOpen Silicon Valley 2017 | 2017-09-06 |
Postgres 10 removes the dotted versioning and renames xlog paths/functions to WAL (so update scripts), defaults wal_level to replica and enables streaming and… | ||
| Not just for rockets anymore | foss-north 2017 | 2017-04-26 |
In today's world where everything moves towards https and other TLS secured connections, certificate management is more important than ever. Through the use of… | ||
| Breakout Session | PGConf Silicon Valley 2015 | 2015-11-17 |
PostgreSQL 9.5 arrives with concrete changes: UPSERT (INSERT ON CONFLICT) provides atomic insert-or-update with an excluded virtual row, 2,700 files modified… | ||
| What's New in PostgreSQL 9.4 | PostgresOpen 2014 | 2014-09-17 |
PostgreSQL 9.4 adds concrete, usable features: jsonb stores parsed JSON but does not preserve key order and supports GIN/GIN‑trgm indexing for fast containment… | ||
| What's New in PostgresSQL 9.3 | PostgresOpen 2013 | 2013-09-16 |
PostgreSQL 9.3 ships (released Sept 9) with about 227,000 lines added and ~100,000 removed and delivers concrete changes: SQL-level lateral queries and richer… | ||
| Secure Your Web Webapp passwords in PostgreSQL | PostgresOpen 2013 | 2013-09-16 |
Outlines a concrete design: rename the user table to a shadow table, revoke select on shadow from the web role, expose a trimmed view with nulled secrets, and… | ||
| PostgreSQL Backup Strategies | Postgres Open 2012 | 2012-09-17 |
Replication does not replace backups: a real outage once nukes 5,000 VMs and takes months to recover. Concrete options: pg_dump (custom format) for logical… | ||
| Data Driven Cache Invalidation | EuroPython 2011 | 2011-06-20 |
Shows how to invalidate HTTP caches from the database by sending Varnish purge requests from Postgres. Uses triggers + PL/Python for a simple synchronous purge… | ||
| Data Driven Cache Invalidation | EuroPython 2011 | 2011-06-20 |
Demonstrates a concrete system: a Django app on PostgreSQL, Varnish fronting it, and DB-side invalidation using PostgreSQL triggers that either call PL/Python… | ||
| nothing matches | ||