PostgreSQL autovacuum, explained for engeneers - slides from PostgreSQL Meetup at Zalando Berlin HQ

Filter

PostgreSQL autovacuum, explained for engeneers – slides from PostgreSQL Meetup at Zalando Berlin HQ

At the first Russian PGDay there was a sort of joke, right after PostgreSQL DBA tutorial: „we need an autovacuum tutorial“. The topic is utmost important, poor configured vacuuming can easily screw your database up, but documentation covers only how to configure something (and that is the purpose of documentation), not a word about strategy and common approaches of autovacuum configuration for different workloads.

My talk at Berlin PostgreSQL meetup is some sort of alfa version: I improve it based on the feedback and will include more details and corner cases to present it on PGDay Russia 2015 at Sankt-Petersburg this July.

Stay tuned and thanks for German colleagues for a nice discussion!

Paket	Preis*
PostgreSQL Configuration-Analyse	ab 500 €
Hardware und Betriebssystem Analyse	ab 600 €
Analyse langsamer SQL-Abfragen	ab 500 €
Umfassender Health Check	ab 3500 €
* für eine einzelne PostgreSQL Installation (1 master und 1 replica)

Basic	Premium	VIP
Inkl. bis zu 5 Stunden Beratungszeit pro Monat	Inkl. bis zu 15 Stunden Beratungszeit pro Monat	Inkl. bis zu 30 Stunden Beratungszeit pro Monat
Slack, Mattermost, Telegram	Slack, Mattermost, Telegram	Slack, Mattermost, Telegram
Antwortzeit bis zu — 1 Stunde	Antwortzeit bis zu — 1 Stunde	Antwortzeit bis zu — 30 Minuten
2 PostgreSQL Instance max	5 PostgreSQL Instance max	10 PostgreSQL Instance max

Nachrichten und Blog zurück

PostgreSQL autovacuum, explained for engeneers – slides from PostgreSQL Meetup at Zalando Berlin HQ

Das könnte Sie auch interessieren:

Taming large datasets in PostgreSQL: archiving and retention without the pain

How to Upgrade RDS PostgreSQL with Minimal Downtime

Open Source Business Alliance (OSBA) publishes procurement recommendations for Open Source software

pgBackRest preview: verify recovery target timeline on restore