How do PostgreSQL's VACUUM optimizations affect dead tuple metrics? Find out why they might persist or reappear when using VACUUM.
CREATE INDEX: Data types matter
Data types play a crucial role in ensuring optimal performance, efficiency, as well as semantics. Read more about CREATE INDEX.
PostgreSQL Trusted Extensions for Beginners
Especially beginners are often having problems concerning the concept of Trusted Extensions. Let's fix that!
Orphaned files after a PostgreSQL crash
by
Laurenz Albe |
04.2025This article describes how a PostgreSQL crash can leave some orphaned files behind and what you can do to get rid of them.
Type alignment and padding bytes: how to not waste space in PostgreSQL tables
by
Laurenz Albe |
04.2025Learn 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.
Indexing vectors in PostgreSQL
Efficiency is always a topic. Therefore, it is important to understand that indexing is the key to success. Read more about indexing vectors.
pgai: Importing Wikipedia into PostgreSQL
In this blog posting you can read more about how we can import Wikipedia into PostgreSQL and make use of it by using pgai.
Using pgvector for timeseries data
pgvector is a popular PostgreSQL extension for semantic search, facilitating discussions on AI and related topics.
Semantic Search in PostgreSQL: An Overview
PostgreSQL enhances search capabilities with extensions like pgvector, enabling advanced semantic search. Find out more in this blog posting.
Debugging PostgreSQL more easily
PostgreSQL powers many applications. In this blog posting you can read more about how to debug database applications effectively.