filmov
tv
s02e14: PostgreSQL major upgrade – что может пойти не так? Гость: Александр Кукушкин
Показать описание
- Апгрейд на 12 и 13
- Риски апгрейда
- 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)
Комментарии