PGConf Europe 是欧洲最大的 PG 会议，PGConf.EU 2023 于 12 月 12-15 日在捷克首都布拉格举办。本文摘录一些我感兴趣的议题。
会议的时间表: https://www.postgresql.eu/events/pgconfeu2023/schedule/
General
- Elephant in a nutshell - Navigating the Postgres community 101
- 介绍 PostgreSQL 社区的运作机制
- Speaker: Valeria Kaplan
- Slides: PGconf.EU. 2023_Valeria’s talk - Elephant in a nutshell.pdf
DBA
-
Getting the most out of pg_stat_io
- PG16 引入了 pg_stat_io 视图，提供了很多 I/O 相关的细节，包括扩展、读取和写入，以及与缓冲区缓存相关的统计信息。
- Speaker: Daniel Westermann
- Slides: PGCONFEU-pg_stat_io.pdf
-
Performance tricks you have never seen before-V2
- Speaker: Hans-Jürgen Schönig
- Slides: Performance tips you have never seen before - V2 (1).pdf
-
The journey towards active-active replication in PostgreSQL
- 介绍了逻辑复制的发展历程及 active-active 复制相关的特性支持
- Speaker: Jonathan S. Katz
- Slides: pgconfeu2023_active_active.pdf
-
Understanding and Fixing Autovacuum
- 介绍 autovacuum 常见的问题及解决方案。
- Speaker: Robert Haas
- Slides: Understanding and Fixing Autovacuum - PGCONF.EU 2023.pdf
-
PostgreSQL Distributed: Architectures & Best practices
- 介绍了对分布式数据库的一些思考
- Speaker: Marco Slot
- Slides: Distributed PostgreSQL 2023.pdf
-
How to corrupt your database (and how to deal with data corruption)
- 如果你知道了如何搞崩你的数据库，你自然就知道如何避免让你的数据库崩溃。
- Speaker: Laurenz Albe
- Slides: data_corruption.pdf
-
PostgreSQL Security: The defense line for your data
- Speaker: Julia Gugel
- Slides: PostgreSQL_security_with_demo.pdf
-
Pgpool - What, Why, and Where?
- Speaker: Muhammad Usama
- Slides: PGConf.EU 23 Pgpool - What, Why, Where.pdf
-
Use Ansible to herd your Elephants!
- Speaker: Julian Markwort
- Slides: ansible_to_shepherd_your_elephants.pdf
-
Don’t Do High Availability, Do Right Availability
- Speaker: Greg Vernon
- Slides: Right_avail_pgconfeu.pdf
-
Postgres vs. Linux filesystems
- Speaker: Tomas Vondra
- Slides: postgres-vs-filesystems-pgconfeu-2023.pdf
-
How we execute PostgreSQL major upgrades at GitLab, with zero downtime.
- Speaker: Alexander Sosna
- Slides: 2023.pgconf.eu Zero Downtime PostgreSQL Upgrades.pdf
-
Postgres 16 highlight: Logical decoding on standby
- Speaker: Bertrand Drouvot
- Slides: pgconfeu2023_logical_decoding_on_standby.pdf
-
PostgreSQL Replication: 20 Pitfalls and Solutions
- Speaker: Julian Markwort
- Slides: postgres_replication_pitfalls_and_solutions.pdf
-
What can’t pgBackRest do for you?
- Speaker: Stefan Fercot
- Slides: 20231215_PGConfEU_What-cant-pgBackRest-do-for-you.pdf
-
PostgreSQL Write-Ahead Logging (WAL): The Internals of Reliability and Recovery
- Speaker: Hamid Akhtar
- Slides: PostgreSQL Write-Ahead Logging (WAL)_ The Internals of Reliability and Recovery.pdf
-
Professional PostgreSQL monitoring made easy
- Speaker: Pavlo Golub
- Slides: Monitoring PostgreSQL made simple - pgconf.eu'23.pdf
-
Leveraging pgBadger for Effective PostgreSQL Troubleshooting
- Speaker: Alicja Kucharczyk
- Slides: Leveraging pgBadger for Effective PostgreSQL Troubleshooting-pgconfeu.pdf
Developer
-
Vectors are the new JSON
- 向量是一个历经多个世纪研究的数学概念，但在数据库系统中，它们在高效存储和检索方面仍面临许多挑战。AI/ML的易用性提高导致人们对将向量数据与应用数据存储在一起产生了浓厚的兴趣，从而带来了一些独特的挑战。PostgreSQL 在 JSON 成为 Web 通用语言时曾经历过类似的情况。那么，使用 PostgreSQL 管理向量数据应该注意哪些挑战呢？
- Speaker: Jonathan S. Katz
- Slides: pgconfeu2023_vectors.pdf
-
A journey into postgresql logical replication
- Speaker: José Neves
- Slides: A journey into postgresql logical replication.pdf
-
How I found my Pokémon cards thanks to Postgres: an AI journey
- Speaker: Matt Cornillon
- Slides: how-i-found-my-pokemon-cards-thanks-to-postgres-an-ai-journey
-
Beginner’s Guide to Partitioning vs. Sharding in Postgres
- Speaker: Claire Giordano
- Slides: Beginner’s Guide to Partitioning vs. Sharding in Postgres | Claire Giordano | PGConf EU 2023
-
Counting things at the speed of light with roaring bitmaps
- Speaker: Ants Aasma
- Slides: roaring.pdf
-
It’s Not You, It’s Me: Breaking Up with Massive Tables via Partitioning
- Speaker: Chelsea Dole
- Slides: Breaking Up Massive Tables with Partitioning.pdf
-
Learning advanced SQL the weird (and hard) way
- Speaker: Lætitia AVROT
- Slides: https://tinyurl.com/ye9pxyeu
-
Should I use JSON in PostgreSQL?
- Speaker: Boriss Mejias
- Slides: bmejias_should_I_use_json.pdf
-
Blazingly Fast Message Queue on Postgres with Rust
- Speaker: Adam Hendel
- Slides: PGConfEU 2023 - MQ on PG.pdf
-
PostGIS and pgRouting: Extensions for spatial data in PostgreSQL
- Speaker: Marion Baumgartner
- Slides: postGISPGRoutingPresentation.pdf
Internals
-
Multi-threaded PostgreSQL?
- 将 PG 改为多线程架构似乎是一个很困难的事情，但比起 10 年前要可能性更大了，操作系统、编译器的支持更加完备，依赖的库也都提供 thread-safe 的接口。
- Speaker: Heikki Linnakangas
- Slides: Multi-threaded PostgreSQL .pdf
-
Making your patch more committable
- Speaker: Melanie Plageman
- Slides: Making your patch more committable
-
The path to using AIO in postgres
- Speaker: Andres Freund
- Slides: path-to-aio.pdf
-
PostgreSQL hacker tips
- Speaker: Michael Paquier
- Slides: PGConfEU2023_PostgreSQL_Hacker_Tips.pdf