Developing PostgreSQL Extensions in C: Hooks, Shared Memory & Best Practices
Developing PostgreSQL Extensions in C: Hooks, Shared Memory & Best Practices
Speaker: Suresh dash (Fujitsu)
🔗 https://live.pgconf.in/events/pgconf-...
PGConf India 2026 — Asia's Premier PostgreSQL Conference
March 11-13, 2026 | Sheraton Grand Hotel, Bangalore
https://pgconf.in
---
PostgreSQL’s extensibility empowers developers to build powerful, custom functionality directly within the database. Writing extensions in C allows maximum performance and integration, but requires a deep understanding of PostgreSQL’s internal architecture, memory management, and hook mechanisms.
This session provides a comprehensive, hands-on exploration of PostgreSQL extension development, including:
Structuring and organizing C-based extensions for maintainability and performance
Leveraging hooks to customize core behavior safely without modifying PostgreSQL itself
Using shared memory and background workers effectively in extensions
Best practices for stability, version compatibility, and debugging
Lessons learned from real-world extension development and common pitfalls to avoid
Attendees will gain practical skills to design robust, high-performance extensions, enhance PostgreSQL functionality, and deepen their understanding of the database’s internals. This talk is ideal for developers, DBAs, and anyone eager to master PostgreSQL extensibility.