From: Alvaro Herrera <alvherre@2ndquadrant.com>
To: bricklen <bricklen@gmail.com>
Cc: Natalie Wenz <nataliewenz@ebureau.com>
Cc: pgsql-admin <pgsql-admin@postgresql.org>
Subject: Re: pg_upgrade and frozen xids
Date: Wed, 7 Mar 2018 16:48:11 -0300
Message-ID: <20180307194811.tloezvberxo33faw@alvherre.pgsql> (raw)
In-Reply-To: <CAGrpgQ_pUDdNXTFZotYoOR-iW-OXtTbFZ-69u-1=4dM+kWVPnA@mail.gmail.com>
bricklen wrote:
> We recently upgraded about 1500 Postgres clusters from 9.3 to 10.1 and we
> are seeing similar issues. Specifically:
> * An autovacuum worker stuck vacuuming regular tables for days until they
> are killed (I've seen "vacuuming indexes" phase), and they are showing 99%
> CPU in top. pg_cancel|terminate_backend does not usually kill the process,
> only a hard kill does. In the latter case, two (out of four) times it also
> crashed Postgres.
> * There have been about 10 examples of btree index corruption, across a
> handful of databases, in different data centres. In two of the cases, it's
> possible there were hardware issues as the hypervisor those two VM's were
> running on crashed.
I wonder if this may be related to changes in collation algorithm. If
the indexes are all on text columns, I think you would be better served
by reindexing them all instead of trying to treat this situation as a
code bug.
--
Álvaro Herrera https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: alvherre@2ndquadrant.com, bricklen@gmail.com, nataliewenz@ebureau.com
Subject: Re: pg_upgrade and frozen xids
In-Reply-To: <20180307194811.tloezvberxo33faw@alvherre.pgsql>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox