1 Antwort
- Neueste
- Die meisten Stimmen
- Die meisten Kommentare
0
You may have already know this and have done this, but in case you have not... PostgreSQL does not carry over statistics between major versions. So, when you do an upgrade from 9.6 to 12 to 13, the statistics used by the query optimizer are lost. This can lead to poor performance and increase in IO. The takeaway is be sure to do ANALYZE after a major upgrade. Here is a blog post that talks about this: https://medium.com/aubergine-solutions/trust-me-you-dont-want-to-miss-this-postgresql-command-after-the-upgrade-99200cbfabaf
beantwortet vor 2 Jahren