postgres=# select * from sessions where video_id = 'EqqByzGHIBk';

GSoC ideas for Postgres

· 69:49 · Hacking process

Turn workshop ideas into scoped GSoC projects, including wait-event coverage, pg_stat_statements scalability, and B-tree page merge.

session summary

The group turned Postgres GSoC brainstorming into a draft set of core-development projects. After Nikolay recounted his 2006 SQL/XML GSoC experience, they evaluated planner, parallel GiST build, TOAST slicing, test coverage, logged/unlogged tables, global temporary tables, and autovacuum ideas. They then added wait-event coverage, pg_stat_statements scalability, and B-tree page merge, using an AI-generated wiki draft. The draft still needed expert validation, clearer mentor ownership, and manual editing before merging into the official ideas page.

timecodes

  1. Nikolay's 2006 SQL/XML GSoC project
  2. Reviewing existing core project ideas
  3. How GSoC ideas, mentors, and proposals match
  4. Logged tables and other deceptively hard projects
  5. Global temporary tables and autonomous work
  6. Autovacuum control and scheduling ideas
  7. Generating the GSoC wiki draft
  8. Wait events, page merge, and observability projects