Date: Wed, 17 Nov 2021 17:18:15 -0600
From: Justin Pryzby <pryzby@telsasoft.com>
To: Robert Creager <robertc@spectralogic.com>
Cc: Thomas Munro <thomas.munro@gmail.com>, Tom Lane <tgl@sss.pgh.pa.us>,
	pgsql-performance@lists.postgresql.org
Subject: Re: Need help identifying a periodic performance issue.
Message-ID: <20211117231815.GF17618@telsasoft.com>
References: <3A76761B-3DDD-4A3C-B791-E73107AFC9A2@spectralogic.com>
 <CA+hUKG+iKkdeS9g1=866pypHZwPMQL2ho+oFWLSpRjV=-PvuCg@mail.gmail.com>
 <0C3B1B2B-6571-477D-A89C-6FA7B6259840@spectralogic.com>
 <20211117190038.GB17618@telsasoft.com>
 <2736634.1637177330@sss.pgh.pa.us>
 <CA+hUKGKmn0g2nb6W7-kh=iGPLise=sLhiVJjBS+wV1ofDuci4g@mail.gmail.com>
 <5BAA534E-AECC-4533-951A-0B6D88A070F3@spectralogic.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Disposition: inline
Content-Transfer-Encoding: 8bit
In-Reply-To: <5BAA534E-AECC-4533-951A-0B6D88A070F3@spectralogic.com>
User-Agent: Mutt/1.9.4 (2018-02-28)
Archived-At: 
 <https://www.postgresql.org/message-id/20211117231815.GF17618%40telsasoft.com>
Precedence: bulk

On Wed, Nov 17, 2021 at 09:54:14PM +0000, Robert Creager wrote:
> We are able to move up to Postgres 13.5, in our ports tree, if that would help.  We used pg_upgrade to get from 9.6 to 13.3, so that should work fine going instead to 13.5.  We’re almost branching/releasing our code, so it’s not a good time, but if it may help with this problem, we’ll deal with it.

To be clear, I have no specfic reason to believe it would help.
But it would be silly to chase down a problem that someone already fixed 10
months ago (the source of this problem, or something else that comes up).

In fact I suspect it won't help, and there's an issue with your schema, or
autovacuum, or postgres.

Note that since v10, the version scheme uses only two components, and 13.3 to
13.5 is a minor release, similar to 9.6.3 to 9.6.5.  So you don't need to use
pg_upgrade - just update the binaries.

https://www.postgresql.org/docs/13/release-13-5.html

-- 
Justin