VACUUM: Managing and detecting bloat
We will explore the concept of VACUUM in PostgreSQL, its importance, and best practices for implementing effective vacuuming strategies.
GRANT VACUUM, ANALYZE in PostgreSQL 16
What is GRANT VACUUM, ANALYZE? PostgreSQL uses table VACUUM and ANALYZE commands to optimize the database. The VACUUM command reclaims […]
VACUUM does not shrink my PostgreSQL table
Did you ever wonder why VACUUM does not shrink PostgreSQL data files? Learn all the most useful secrets of VACUUM.
Disabling autocommit in PostgreSQL can damage your health
by
Laurenz Albe |
06.2021 When analyzing customer's problems, I have seen the mess you can get into if you disable autocommit in your […]
In many PostgreSQL databases, you never have to think or worry about tuning autovacuum. It runs automatically in the […]
7 things that could be improved in PostgreSQL
UPDATE July 2023: What could be better in PostgreSQL? Find out about its weak points, and see what has improved since 2020.
PostgreSQL v13 new feature: tuning autovacuum on insert-only tables
by
Laurenz Albe |
04.2020 Most people know that autovacuum is necessary to get rid of dead tuples. These dead tuples are a side […]
Discovering less-known PostgreSQL v12 features
Get to know and learn how to use some less-known features of Version 12 of PostgreSQL. You'll surely discover something new for yourself.
What is autovacuum doing to my temporary tables?
The main issue is that autovacuum does not touch temporary tables. Yes, it’s true – you have to VACUUM temporary tables on your own. Read more
A beginners guide to PostgreSQL's UPDATE and autovacuum
This article is a beginners guide about how PostgreSQL handles UPDATEs, about VACUUM as well as autovacuum and it's limitations.
