Pre-Conference Travels: Debian & Berlin The week before this year's PGConf.DE, I attended the Debian MiniDebConf in Hamburg. Adding Berlin […]
From insightful talks and customer meetings to the big launch of the Open Alliance for PostgreSQL Education (OAPE), we came […]
Data types play a crucial role in ensuring optimal performance, efficiency, as well as semantics. Read more about CREATE INDEX.
Especially beginners are often having problems concerning the concept of Trusted Extensions. Let's fix that!
This article describes how a PostgreSQL crash can leave some orphaned files behind and what you can do to get rid of them.
Learn the concepts of data type alignment and padding bytes in PostgreSQL and how to define your table so that you don't waste storage space.
Efficiency is always a topic. Therefore, it is important to understand that indexing is the key to success. Read more about indexing vectors.
In this blog posting you can read more about how we can import Wikipedia into PostgreSQL and make use of it by using pgai.
pgvector is a popular PostgreSQL extension for semantic search, facilitating discussions on AI and related topics.
My impressions from the Swiss Database Synergy Day 2025, a conference organized by the Swiss Oracle and PostgreSQL user groups
PostgreSQL enhances search capabilities with extensions like pgvector, enabling advanced semantic search. Find out more in this blog posting.
Find out more about my first visit to PGDay Paris 2025 in this blog post, what I experienced and what lessons I learnt.
