[PostgreSQL] Vaccum 수행 필요 대상 추출
2024. 6. 20.
-- Vacuum threshold(autovacuum 임계값) = vacuum base threshold + vacuum scale factor * number of tuples with avt as ( select setting as autovacuum_vacuum_threshold from pg_settings where name = 'autovacuum_vacuum_threshold' ) , vsf as ( select setting as autovacuum_vacuum_scale_factor from pg_settings where name = 'autovacuum_vacuum_scale_factor' ) , fma as ( select setting a..