PGConf India 2025
| title | author | length |
|---|---|---|
| Round Table Discussion | 37m | |
Panelists debate concrete paths for Postgres to serve AI: adoption of PG Vector today but need for new index types and GPU/TPU support for higher… | ||
| Common mistakes of DBAs | Soqra Banu Rumi | 05m |
Founder-run Postgres service with 12 years of experience lists concrete DBA failures and fixes: rely on a 3-2-1 backups approach with standby servers in… | ||
| Data aesthetics | Ashutosh Bapat | 03m |
Code written in Python reads Postgres data directory and uses relation forks to pull raw row-and-column bytes, then writes binary as BMP by assigning… | ||
| Delivery Consultant | Ashish Srivastava | 04m |
Overview of PostGIS for PostgreSQL, claiming storage of geometry as true spatial types (points, polygons), spatial indexes to speed queries, and a live example… | ||
| GraphQL Revolutionizing API Development | Jitendra Kumar | 03m |
A Postgres-native GraphQL extension implemented in C and SQL exposes a single endpoint that replaces multiple REST routes, serves queries that avoid over‑ and… | ||
| Migration Consideration Oracle to PostgreSQL | Neeta Goel | 06m |
Claims that successful Oracle→PostgreSQL migration requires upfront discovery of unsupported Oracle features, explicit handling of schema complexity and… | ||
| PostgreSQL at Amazon | Jim Mlodgenski | 18m |
Timeline of AWS Postgres work: RDS launches 2009, Redshift (Postgres-based) in 2013, RDS for Postgres (9.3.2) follows, then Aurora for Postgres with… | ||
| AI-Assisted Post-Mortem Analysis for PostgreSQL | Yugank S | 30m |
AI-assisted post-mortem claims to turn bulky Postgres logs into actionable RCA and tuning steps using monitoring + LLMs; a live SQLdo.ai demo connects to an… | ||
| Community Involvement for the Introvert | Pat Wright | 36m |
Advice focuses on concrete steps: submit three separate proposals, rehearse the slide deck at least three times and present to an empty room, expect a 45–60… | ||
| Beginner's Guide to Partitioning vs Sharding in Postgres | Claire Giordano | 42m |
Partitioning is a built‑in Postgres feature with three modes Partition by range/list/hash that speeds queries when a WHERE on the partition key lets Postgres… | ||
| Enhancing Security in PostgreSQL | Kshetrapaldesi Tutika | 32m |
PostgreSQL security changes from Version 10 to 17 include concrete, actionable shifts: create on schema revoked by default (v15+) so non-owners need explicit… | ||
| Failover Slots in PostgreSQL-17: | Nisha Moond | 37m |
PostgreSQL 17 adds real‑time replication of selected logical slots to the standby so subscribers can resume without full resync; configure slots with… | ||
| Postgres: ServerLESS is more? | Nikhil Sontakke | 45m |
Proposes separating Postgres into thin compute nodes and two storage services: shared WAL storage and an LSN-versioned page server that stores multiple page… | ||
| Securing PostgreSQL From External Attack | Bruce Momjian | 35m |
Examines concrete external attack vectors and concrete defenses: default pg_hba often grants trust on local sockets, MD5 auth is legacy while SCRAM-SHA-256 is… | ||
| Sharded & Distributed Are Not the Same: | Evgenii Ivanov | 31m |
Claims that Citus is not ACID for multi-shard transactions and that two-phase commit only provides atomic commit (not isolation) drive the talk; proof comes… | ||
| Optimising Column Order for Better Performance & Maintainability | Amul Sul | 39m |
Shows that reordering columns to group fixed-width types before varlena removes padding and shrinks row size 56→46 bytes, which on a 1M-row test drops table… | ||
| Being mindful of query optimizer | Rakesh Ra, Puja A | 45m |
A migration checklist focused on measurable differences: DB2 compiles PL/SQL with semantic checks and stores executable plan in memory, PostgreSQL often defers… | ||
| Reliability features in Postgres Pro | Leonid Albrekht | 57m |
PostgresPro ships an integrated HA layer called beha that uses raft consensus and a custom BCP protocol with a beha_worker process to perform automatic… | ||
| When it all GOes right | Pavlo Gulob | 43m |
Go plus PostgreSQL workflow with concrete tools: use PGX native features instead of lib/pq for native types, prepared-statement caching, COPY and… | ||
| Scaling Semantic Search in PostgreSQL | Gunjan Juyal | 44m |
PGVector on PostgreSQL supports IVF‑flat and HNSW indexes; HNSW gives best runtime but needs huge memory — approximate formula shows 1M vectors ≈6 GB, 10M ≈65… | ||
| EDB & Postgres through the years and in the years to come | Tom Kincaid | 14m |
EDB traces 20 years of concrete contributions: it builds and upstreams features like Heap-only tuples (HOT), streaming replication, parallel query, declarative… | ||
| Something Got Better For Partitioning in v18 Unless Reverted | Amit Langote | 06m |
Shows that Postgres v18 makes generic plans practical for partitioned tables by moving partition locking until after runtime pruning, so the planner no longer… | ||
| pgextensions org Your Guide to PostgreSQL Extensions Comparision on the Cloud | Akash Gupta | 05m |
pgextensions.org is a searchable comparison that maps which PostgreSQL extensions each cloud provider and managed service supports and flags compatibility gaps… | ||
| How to play Wordle in Postgres | Pavlo Golub | 04m |
Shows a working Wordle implementation inside Postgres using psql and SQL only, breaking words into letters and using simple queries and similarity functions to… | ||
| Enhancing Planner Estimates with Extended Statistics in PostgreSQL | Kshetrapaldesi Tutika | 04m |
PostgreSQL shows large estimation errors on correlated columns; creating CREATE STATISTICS on the specific column pair and running ANALYZE moves an estimate… | ||
| Data Masking in PG | Nishant Sharma | 04m |
Compares three Postgres extensions and finds Postgres SQL Anonymizer actually meets requirements, installs as an extension and runs SQL to produce realistic… | ||
| Beyond NoSQL The Case for Postgres in Read Heavy Workloads | Praveen Upadhyay | 06m |
Migrated a small, read‑heavy service from Cassandra+cache to Postgres and sees concrete gains: original workload is 90:10 read:write so caches constantly… | ||
| ML for Systems and Systems for ML | Luigi Nardi | 06m |
Frames the field as two concrete directions: building systems to run ML and using ML to improve systems. Lists actual platforms and results: TensorFlow and… | ||
| My Journey to PostgreSQL the PGCA Board of Directors | Claire Giordano | 06m |
Personal journey into PostgreSQL leads to work with the PGCA nonprofit that maintains and enforces PostgreSQL trademarks and domain assets, negotiating no-cost… | ||
| Never be on call again | Pat Wright | 05m |
Claims that on-call duty disappears if recovery steps are written so anyone can follow them, with a concrete rule: start with a list rather than a 90‑page… | ||
| Postgres Tuning is saved by Sovenath Shaw | Sovenath Shaw | 04m |
A tiny runtime agent of roughly 20 lines of code continuously gathers metrics and tests combinations of parameters like max_parallel_workers_per_gather and… | ||
| PostgreSQL JSON JSONB Making the Right Choice for Your Application | Tummala Aswini Kumar | 05m |
PostgreSQL supports two JSON types: introduced in 9.2 JSON stores the text as-is (preserving whitespace and formatting) while binary parsed tree JSONB parses… | ||
| Supercharging GenAI PostgreSQL Vector Search Optimization | Rajkumar Raghuwanshi | 04m |
Practical PostgreSQL PGVector tuning for cheaper RAG: recommends starting IVF_FLAT cluster count near the square root of 10k embeddings (≈100) then adjust for… | ||
| The ESR Equality Sort Range Rule of Composite Indexes | Franck Pachot | 03m |
Explains a concrete rule for Postgres composite indexes: put all equality first columns, then range columns, then the columns used for ORDER BY/LIMIT so the… | ||
| Trade offs and Considerations for PostgreSQL CLUSTER Command | Tummala | 04m |
Clustering a table yields faster sequential and range query reads for reporting heavy workloads but costs more memory, CPU and time to build and table lock… | ||
| Diamond Sponsor Hall | 01h 02m | |
Google Cloud outlines three concrete choices and migration paths: Cloud SQL Enterprise Plus for managed, drop-in Postgres with one‑second scale-ups and… | ||
| Things your explain plan is not telling you | Ants Aasma | 40m |
Shows concrete gaps in PostgreSQL EXPLAIN: large JSONB values (10,000 rows with 32 KB each) are stored in a TOAST table so EXPLAIN can report 0.9 ms but real… | ||
| Platinum Sponsor Hall | 23m | |
IITM Pravartak explains concrete work: porting and optimizing PostgreSQL for indigenous hardware and teaching a deep-core database course, claims the Shakti… | ||
| Hacking Postgres Executor For Performance | Amit Langote | 47m |
Talk documents concrete patches and bigger ideas: expression evaluation is flattened into a single function since v10, ExecProcNode dispatch is replaced by… | ||
| Accelerating PL/pgSQL Code Conversion | Deepak Mahto | 39m |
Migration often spends roughly 50% of effort on code conversion, especially for projects approaching 1,000,000 lines of code. PL/pgSQL compiles with minimal… | ||
| Experimental approach towards Replication in Postgres | Balaji Venkat | 23m |
Experimental prototype replaces Postgres TCP unicast streaming with PIM-BIDIR multicast sockets to cut primary CPU, kernel buffer and NIC bandwidth by sending… | ||
| Extending your database server's abilities | Hannu Krosing | 33m |
Argues for moving business logic into the database by packaging operations as functions that reduce client roundtrips and lock contention, showing pgbench… | ||
| pgBackRest: Elevating PostgreSQL Backup Game | Sonia Valeja | 41m |
pgBackRest installs from packages, uses a repo at data/data/backups, and configures a stanza holding metadata; demo shows enabling archive_command enabled… | ||
| lesser known Superpower of Postgres Logical Replication | Kevin Biju | 42m |
Explains how Postgres logical replication evolved from V1 (only post-commit) to V2 (in‑progress streaming), V3 (prepared transactions) and V4 (parallel apply)… | ||
| Navigating Challenging Customer Escalations in Postgres | Dilip Kumar, Rushabh Lathia | 01h 07m |
Describes concrete failure modes and mitigations: a hard 64 subtransaction per-backend cache limit causes subtransaction cache overflow (customers hit 300–900… | ||
| Collation Challenges: Sorting it Out | Joe Conway | 46m |
Postgres collations change when underlying glibc changes and that can silently corrupt btree indexes and constraints: upgrading RHEL7 (glibc 2.17) databases to… | ||
| Leading the Future of Postgres Together | Aarti Nadekar, Brahmini Meruva | 12m |
Postgres Women India grows a LinkedIn page from 4 to 1,200 followers and runs training, mentorship and outreach focused on Postgres data and AI; the upskill… | ||
| Opening Note | Nikhil Sontakke | 10m |
Opening note lists concrete logistics and wins: 525+ attendees from 80+ cities and 20+ countries, backed by AWS EDB Google Cloud Microsoft and multiple… | ||
| Reproduce those complex query planner issues | Gaurav Kukreja | 30m |
Tool CBO stat dump extracts pg_class relpages/reltuples, pg_statistic and pg_statistic_ext, DDL, GUCs and query plans so a test cluster with empty tables… | ||
| Using Postgres to locate the best coffee near you! | VARUN DHAWAN | 42m |
A practical walkthrough that turns a Zomato dump of 8,000 businesses and 50,000 reviews into a working search: JSON ingestion into Postgres, TSVector… | ||
| Understanding Write-Ahead Logging (WAL) in PostgreSQL | Vigneshwaran | 44m |
Explains how WAL stores a sequential change log in 16 MB segments split into 8 KB pages, with LSNs formed from timeline/file/segment hex fields; WAL records… | ||
| PostgreSQL: Page Buffer Overview | Harish Perumal | 39m |
Explains how PostgreSQL keeps 8KB pages in a shared buffer (default 128 MB, recommended ~25% RAM) and a hash lookup maps requests to ~16,364 buffer slots; page… | ||
| Unleashing the Power of Azure for PostgreSQL | Shriram M | 50m |
Flexible Server shows concrete features and numbers: synchronous HA with same‑zone or zone‑reduant failover and up to five replicas and geo‑redundant backups… | ||
| Beginner's guide to PostgreSQL Hacking | Pavan Deolasee | 47m |
Shows how to get and build PostgreSQL from source: use git and git worktree to manage versions, configure with debugging flags (enable-debug, enable-depend… | ||
| Building reliable infrastructure with Postgres | Andrey Fleyta | 13m |
PostgresPro describes a fork aimed at huge enterprise installs with built‑in HA cluster and multi‑master replication, a sharding system running a 300 TB… | ||
| Graph databases, PostgreSQL and SQL/PGQ | Ashutosh Bapat | 45m |
Maps relational tables to property graphs so rows become nodes and foreign keys become edges, and demonstrates SQL/PGQ as a SQL standard that lets you write… | ||
| How to Upgrade Replication Clusters without Downtime? | Shlok Kumar Kyal | 36m |
PG upgrade remains the fast option for major-version moves (about 7× faster than dump/restore), but until PG17 upgrades require stopping instances, recreating… | ||
| Modern SQL features in PostgreSQL | Jobin Augustine | 48m |
PGBench shows tiny network delays crush throughput — 0.01 ms yields ~60,000 TPS, 0.28 ms drops to ~35,000 and 0.48 ms to ~2,000 — so reducing round trips is… | ||
| Building Scalable APIs: PostgreSQL Meets GraphQL | Shalaka D, Ramya B | 45m |
Shows a working Node.js + React demo that uses a single /graphql endpoint with resolvers that translate GraphQL operations into SQL against PostgreSQL; the… | ||
| Closing Note | Ashish Mehra | 20m |
Conference reports 200+ submissions and selects 35 slots; attendees come from 80 cities and 20 countries representing about 150 organizations. Major sponsors… | ||
| Performance is a feature: accelerating Postgres | Anup Sharma | 40m |
Shows that moving compute into Postgres via extensions and PL languages yields big wins: a moving‑average job on 1M transactions runs ~1.8s locally vs ~12s… | ||
| Postgres as a Message Broker | Hemendra Sharma | 23m |
Postgres replaces RabbitMQ/Redis for async work by storing tasks in SQL, using Redis as a buffer and Lambdas to bulk insert 1k–2k rows, consumers fetching… | ||
| All the Postgres Things | Sujit Kuruvilla | 16m |
Microsoft-contributed code totals 412 commits in Postgres 17 including the readstream IO combining that reduces small 8K reads to fewer larger IOs and WAL… | ||
| Observability and Manageability in | Sujatha Mandava | 17m |
Google exposes a new Database Center that inventories Cloud SQL, AlloyDB, Spanner and more, shows all instances, and applies recommended security and… | ||
| GIS capability of PostgreSql using POSTGIS & OSM DATA | Amit Thakur | 40m |
Loads India OSM PBF from Geofabrik, clips to Bangalore with osmium, imports into PostgreSQL using osm2pgsql and enables PostGIS plus S2 and hstore; queries… | ||
| Be Good Friends with Query Planner | Atsushi Torikoshi | 26m |
Postgres tends to pick good plans but misestimates when stats are stale or cardinality grows with many joins; run ANALYZE after big updates and use… | ||
| Day 1 Highlights | 05m | |
Audio contains only opening music and repeated applause with no technical narration or claims, so there are no spoken content about PostgreSQL features… | ||
| nothing matches | ||