{"id":13327,"date":"2026-02-17T09:30:42","date_gmt":"2026-02-17T08:30:42","guid":{"rendered":"https:\/\/www.credativ.de\/?p=13327"},"modified":"2026-02-16T14:38:34","modified_gmt":"2026-02-16T13:38:34","slug":"cern-pgday-2026-an-extraordinary-postgresql-event","status":"publish","type":"post","link":"https:\/\/www.credativ.de\/en\/blog\/postgresql-en\/cern-pgday-2026-an-extraordinary-postgresql-event\/","title":{"rendered":"CERN PGDay 2026 \u2013 an Extraordinary PostgreSQL Event"},"content":{"rendered":"
\n
\n

CERN PGDay 2026<\/a> took place on Friday, February 6, 2026, at CERN campus in Geneva, Switzerland. This was the second annual PostgreSQL Day at CERN, co-organized by CERN and the Swiss PostgreSQL Users Group. The conference offered a single-track schedule of seven sessions (all in English), followed by an on-site social event for further networking in the inspiring environment of CERN. With around 100 participants, this is already a very large PostgreSQL event for Switzerland. But what made this event absolutely special was its location. Hosting a database conference at CERN \u2013 one of the world\u2019s leading science laboratories \u2013 provided a unique experience for everyone.<\/p>\n


\nOn the day before the conference, Thursday, February 5, CERN invited the speakers and sponsors to an exclusive tour of several facilities that showcased its extraordinary technology and research. We visited the CERN Control Centre (the operational hub for CERN\u2019s accelerator complex), saw the facility where CERN tests superconducting magnets, and explored CERN\u2019s \u201cAntimatter Factory.\u201d In the Antimatter Factory (the Antiproton Decelerator), we learned how CERN produces low-energy antiprotons and binds them with positrons to create antihydrogen atoms for antimatter experiments. This behind-the-scenes visit reminded everyone that we were gathering in a place of cutting-edge science and engineering.<\/p>\n

\"\"<\/a> \u00a0\"\"<\/a> \u00a0\"\"<\/a><\/p>\n<\/div>\n

Diving into Shared Buffers \u2013 My Talk<\/h3>\n
\n

As one of the speakers, I presented a deep technical dive into how PostgreSQL\u2019s shared buffer – titled \u201cThe Alchemy of Shared Buffers: Balancing Concurrency and Performance<\/a>.\u201d In this talk I explained how Linux implements operations with shared memory via tmpfs file system as operations with files and how PostgreSQL uses it to implement its shared memory objects. I dissected the three-layer architecture of shared buffers, the life cycle of a page in shared buffers, what happens during cache hit and cache miss, and buffer rings, that isolate bulk scans or vacuum operations so they do not wipe out the working set in the cache. Despite the deep dive nature of this topic, I received very positive feedback from attendees, which confirmed my previous experience that PostgreSQL conference audiences are hungry for more than just introductory talks.<\/p>\n<\/div>\n

\n

\"\"<\/a> \u00a0\"\"<\/a> \u00a0\"\"<\/a><\/p>\n<\/div>\n

Conference Program Highlights<\/h3>\n