FOSSASIA PGDay 2025
2025-03-14
-- online --
| title | author | length |
|---|---|---|
| Advanced testing with Injection Points | Michael Paquier | 42m |
A new backend feature called PostgreSQL 17 injection points lets tests run custom C callbacks at exact file/line locations; it stores names and cached function… | ||
| PostgreSQL Extension for Full-Text Search in Any Language | Vee Satayamas | 14m |
A PostgreSQL parser extension called Chamkho PG implements a customizable tokenizer (word lists, regex replacements, cluster rules) that handles Thai and many… | ||
| Rethinking Message Queues: PostgreSQL's Role | Joobi S B | 23m |
Argues that PostgreSQL can replace a separate broker for many use cases by implementing a jobs table queue and a push channel, showing LISTEN/NOTIFY for… | ||
| Petabyte-scale Log management in Postgres using Bagger | Chris Travers | 25m |
Bagger manages petabyte-scale logs by ingesting JSON into Kafka and sharding writes into Postgres pairs, replacing a previous ElasticSearch setup that failed… | ||
| Automatic DDL Replication with pgEdge Distributed Postgres | Hari P Kiran | 24m |
Automatic DDL replication for a multimaster Postgres mesh is implemented in pgEdge: logical replication plus a Spock extension layer, Snowflake sequences, a… | ||
| pg_stat_advisor: Optimizing PostgreSQL Planner with Insights | Ilia Evdokimov | 31m |
An extension called pg_stat_advisor watches query estimates (via EXPLAIN ANALYZE), records mismatches into a memory ring buffer, and a background worker every… | ||
| Learned Indexes in PostgreSQL: Theory & Implementation | GARY W EVANS | 30m |
Claims a learned-index prototype for PostgreSQL that trains models externally (using TensorFlow compiled to C++), then deploys them alongside B‑trees as… | ||
| SQL Server to PostgreSQL: Migration Challenges & Solutions | Roneel Rohitesh Kumar, Sameer Kumar | 45m |
Migrating from SQL Server to PostgreSQL hits specific pain points: schema and T‑SQL incompatibilities, backups, collation and case sensitivity, and MVCC… | ||
| PostgreSQL for AI. Real Vector Search in PostgreSQL | Vladlen Popolitov | 41m |
PostgreSQL plus PGVector now hits production-scale vector search: benchmarks report 6–16× speedups and ~75% lower cost versus 2023 results, and a 2025 test on… | ||
| PostgreSQL pgroll: Zero-Downtime, Reversible Migrations | Nishchay Kothari | 38m |
pgroll is a Go single-binary CLI that applies PostgreSQL (14+) schema changes by creating virtual schemas and shadow tables, using triggers and transaction… | ||
| AWS and the PostgreSQL community | Michael Paquier | 23m |
PostgreSQL core grows by about 300,000 C lines per year while the committer pool stays ~30 and Postgres 17 lists 463 core contributors, so maintenance pressure… | ||
| FOSSASIA PGDay 2025 Opening | 02m | |
Morning welcome that frames the day as a community kickoff, names AWS and fuu as sponsors, and says the event gathers companies offering PostgreSQL solutions… | ||
| PGday Closing Remarks | 01m | |
Day two ends at 3:00 and attendees are reminded to check the schedule for other sessions, with day three resuming tomorrow morning. Sponsors listed are AWS and… | ||
| nothing matches | ||