Getting on a hook or PostgreSQL extensibility
summary
Covers PostgreSQL’s internal hook API: which core hooks exist, what capabilities they give extension authors, and examples of extensions that use them. Describes using hooks to implement distributed DDL across multiple PostgreSQL instances (based on Postgres Professional’s shardman work). Shows a technique to extend CREATE TABLE syntax via hooks to add WITH(...) options like distributed_by, num_parts and colocate_with without modifying the PostgreSQL core.
AI-written summary · about
related talks
28mBeyond Postgres: Insights about the PostgreSQL Extensibility
42mPostgreSQL Extensions: A Deep Dive
52mAnarchy in the Database: A Survey and Evaluation of Database Management System Extensibility
48mTricky SQL: Special Features of PostgreSQL's SQL Dialect
52mThe trouble with extensions
46mUse PostgreSQL to Step Up Your Game
56mBreakout Session
53mBreakout Session