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.
PostgreSQL powers many applications. In this blog posting you can read more about how to debug database applications effectively.
"PostgreSQL scales" - what does it mean? Find out what 1 trillion rows in Citus is all about in this blog post.
This article describes the little known parameter stats_fetch_consistency and its potential applications for statistics collection.
We are delighted to announce that PGDay Austria will be returning to Vienna in 2025. Find all updates on the event here.
In this blog posting you can read more about one of the fundamental principles in the realm of databases: "Normalization".
This article offers a comparison between the transaction systems of Oracle and PostgreSQL to help you spot potential migration problems.
