Tag SQL

PostgreSql VACUUM – dba cheat-sheet

17.12.2020

This article is inspired by an actual event that caused the overall application performance of one of our clients applications to drop dramatically due to bad PostgreSql database performance. This was caused by „deleted“ data not beeing actually deleted and therefore slowing down I/O ops on the db. During the analysis of the problem, we gained some knowledge about the PG-internal „vacuuming“ procedure. This knowledge will be shared with you in the following article.

weiterlesen