postgresql
Table of Contents
Connaître l'avancement d'un auto-vaccum
SELECT
pid,
relid::regclass AS table_name,
phase,
heap_blks_total,
heap_blks_scanned,
heap_blks_scanned * 100 / heap_blks_total::float AS percent_complete,
index_vacuum_count,
max_dead_tuples,
num_dead_tuples
FROM
pg_stat_progress_vacuum;
Mise à jour du serveur postgresql de la version 11 à la version 16
Procédure
apt list --installed | grep postg pg_dropcluster 16 main --stop pg_upgradecluster 11 main service postgresql@11-main stop service postgresql@16-main start pg_lsclusters pg_dropcluster 11 main apt-get purge postgresql-11 postgresql-client-11
Bibliographie
postgresql.txt · Last modified: 2024/06/28 14:13 by tychocelchu