pgCon

pgCon
Name	pgCon
Status	Active
Genre	Database
Frequency	Annual
Location	Ottawa, Ontario
Country	Canada
First	2006
Organizer	PostgreSQL Community

pgCon is an annual technical conference focused on the PostgreSQL relational database system. The event brings together developers, administrators, vendors, and users from institutions such as Microsoft, Amazon Web Services, Google, Red Hat, and Debian to share research, engineering practices, and deployment experiences. Presentations and workshops have featured contributors affiliated with University of California, Berkeley, MIT, ETH Zurich, and companies including EDB (EnterpriseDB), Uber Technologies, and Citus Data.

History

pgCon originated in the mid-2000s following gatherings of contributors to the PostgreSQL Global Development Group and related projects such as pgAdmin and PostGIS. Early editions included participation from developers associated with Linux Foundation projects and advocates from organizations like Canonical and SUSE. Over time, keynote speakers and panelists have included engineers from Facebook, researchers from Harvard University, and representatives from standards bodies such as IETF and ISO. Major milestones discussed at the conference have paralleled releases of versions tied to features promoted by contributors from EnterpriseDB, 2ndQuadrant, and academic collaborations with ETH Zurich and University of Toronto.

Format and Activities

The conference typically combines tutorials, training sessions, technical talks, lightning talks, and unconference-style BOF (Birds of a Feather) sessions. Tutorial instructors have come from companies like Percona, Crunchy Data, and Cockroach Labs as well as academic presenters from Carnegie Mellon University and University of Cambridge. Hands-on labs often use infrastructure provided by cloud vendors such as Amazon Web Services, Google Cloud Platform, and Microsoft Azure. Community meetups and sponsor booths represent organizations such as GitHub, JetBrains, Intel Corporation, and Nokia.

Topics and Tracks

Tracks cover a wide range of subjects including performance tuning, replication, logical decoding, storage internals, indexing, JSON support, geospatial extensions, and security. Papers and talks have addressed integrations with PostGIS, TimescaleDB, and Citus; performance benchmarks referencing TPC-C and YCSB; and tools like pg_stat_statements, pg_bench, and pg_restore. Sessions have explored interoperability with Kubernetes, Docker, and OpenShift, and audits of extensions linked to LDAP and Kerberos authentication.

Organization and Governance

Organization is driven by volunteers from the PostgreSQL Global Development Group and regional chapters including contributors from Ottawa. The program committee has included representation from companies such as EnterpriseDB, 2ndQuadrant, Crunchy Data, and academic institutions like University of Oxford and McGill University. Sponsorship tiers often involve firms like Amazon Web Services, Google, Red Hat, Microsoft, and community organizations such as OSGeo. Logistics have been coordinated alongside local partners including Carleton University and municipal bodies related to Ottawa.

Notable Talks and Presentations

Past notable presentations have included deep dives into planner internals presented by contributors formerly employed at Amazon, advances in indexing presented by researchers from MIT and ETH Zurich, and scalability case studies from Uber Technologies and Netflix. Security incident retrospectives referenced work by teams from Google and Microsoft. Demonstrations of extensions such as PostGIS, pgRouting, and PL/pgSQL enhancements have come from maintainers tied to OSGeo, PostGIS Project, and individual contributors associated with PGContributors.

Participation and Attendance

Attendees include core committers from the PostgreSQL Global Development Group, DBAs from enterprises such as Goldman Sachs, engineers from startups like Citus Data and Timescale, and researchers from universities including Stanford University and University of Toronto. Representation spans vendors such as EDB (EnterpriseDB), Percona, Crunchy Data, and cloud providers including Amazon Web Services, Google Cloud Platform, and Microsoft Azure. Volunteer-run scholarship programs have supported participants from international groups affiliated with organizations like FreedomBox Foundation and regional user groups in Europe and Asia.

Impact and Community Contributions

The conference has influenced roadmap decisions and stimulated contributions to projects including PostGIS, pgAdmin, psycopg2, and various client libraries. Collaborative sessions have spawned RFCs and patches merged into core by committers from the PostgreSQL Global Development Group, and have encouraged integrations with orchestration systems such as Kubernetes and observability stacks involving Prometheus and Grafana. Networking at the event has led to commercial partnerships among firms like EnterpriseDB, Red Hat, and Microsoft as well as academic collaborations with institutions like Carnegie Mellon University and ETH Zurich.

Category:Computer conferences