AutoVacuum - Tuning and Monitoring

  Рет қаралды 4,533

PostgresConf South Africa

PostgresConf South Africa

Күн бұрын

Lloyd Albin
PostgresConf South Africa 2019
postgresconf.org/conferences/...
I was recently asked by another PostgreSQL DBA about what could be causing queries to run slow while their application is running but then runs fast again after the application is stopped. While I have given several presentations on this subject, each one has been on a specific cause and not talking about all of them together. I decided I would compile them into a single tuning and monitoring presentation.
These slow queries are reported to me by my developers when they start taking minutes to hours to days, in their test and/or production databases. When they stop the application to load up a fresh copy of the database, the same queries run in milliseconds. I have found that this is caused by the AutoVacuum/AutoAnalyze system or lack there of.

Пікірлер
Effectively securing your PostgreSQL database
40:23
PostgresConf South Africa
Рет қаралды 8 М.
Postgres Extensions
34:31
PostgresConf South Africa
Рет қаралды 7 М.
Задержи дыхание дольше всех!
00:42
Аришнев
Рет қаралды 3,8 МЛН
哈莉奎因以为小丑不爱她了#joker #cosplay #Harriet Quinn
00:22
佐助与鸣人
Рет қаралды 7 МЛН
Basic understanding of EXPLAIN ANALYZE
36:08
PostgresConf South Africa
Рет қаралды 25 М.
PostgreSQL performance in 5 minutes
32:39
PostgresConf South Africa
Рет қаралды 57 М.
What's all this fuss about Common Table Expressions (CTE's) anyway?
30:50
PostgresConf South Africa
Рет қаралды 2,9 М.
PostgreSQL/PostGIS devops with Docker and Rancher
35:53
PostgresConf South Africa
Рет қаралды 1,9 М.
Event Stores and Postgres
36:39
PostgresConf South Africa
Рет қаралды 2 М.
Задержи дыхание дольше всех!
00:42
Аришнев
Рет қаралды 3,8 МЛН