pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Justin Pryzby <pryzby@telsasoft.com>
To: Robert Creager <robertc@spectralogic.com>
Cc: Thomas Munro <thomas.munro@gmail.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-performance@lists.postgresql.org
Subject: Re: Need help identifying a periodic performance issue.
Date: Wed, 17 Nov 2021 17:18:15 -0600
Message-ID: <20211117231815.GF17618@telsasoft.com> (raw)
In-Reply-To: <5BAA534E-AECC-4533-951A-0B6D88A070F3@spectralogic.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>

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





view thread (28+ messages)  latest in thread

Message-ID: <20211117231815.GF17618@telsasoft.com>
Permalink:  ../20211117231815.GF17618@telsasoft.com/
Also on:    postgresql.org/message-id/20211117231815.GF17618@telsasoft.com

 · 

reply
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-performance@postgresql.org
  Cc: pryzby@telsasoft.com, robertc@spectralogic.com, thomas.munro@gmail.com, tgl@sss.pgh.pa.us, pgsql-performance@lists.postgresql.org
  Subject: Re: Need help identifying a periodic performance issue.
  In-Reply-To: <20211117231815.GF17618@telsasoft.com>

* 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