s02e14: PostgreSQL major upgrade – что может пойти не так? Гость: Александр Кукушкин

Главный док (подробности, ссылки):
Апгрейд на 12 и 13 Риски апгрейда Analyze vs vacuum
Vacuum truncating last free pages
Patroni - failover failures rsync ANALYZE in stages vs. per-column STATISTICS Backups: Don’t forget to change the destination (bucket or folder) Right after upgrade we have gap -- risk for DR -- until we do a new full backup Planner behavior, version specific: 11: parallelization by default 12: CTE -- “MATERIALIZED” 13: JIT enabled by default -- turn off if OLTP? More (not covered in this episode): Execution plan flips и что с ними делать


If you want to upgrade OS - glibc version upgrade - index corruption risks



Cannot stop or restart Postgres – check archive_command and how many WALs are pending (and kill the archiver process if needed)