Re: Need help identifying a periodic performance issue.

Поиск
Список
Период
Сортировка
От Robert Creager
Тема Re: Need help identifying a periodic performance issue.
Дата
Msg-id 1ADFE43B-5A43-40DA-B039-2D7E5FD82B6C@spectralogic.com
обсуждение исходный текст
Ответ на Need help identifying a periodic performance issue.  (Robert Creager <robertc@spectralogic.com>)
Ответы Re: Need help identifying a periodic performance issue.  (Thomas Munro <thomas.munro@gmail.com>)
Список pgsql-performance

> On Nov 17, 2021, at 4:18 PM, Justin Pryzby <pryzby@telsasoft.com> wrote:
> 
> This message originated outside your organization.
> 
> 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
to13.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.

I figured as much, and told our gang that also.  Was looking through the release notes a little, need to finish with 4
andlook at 5.
 

> 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).

Yeah, trying to figure out how feasible it is for us to do quickly.  Ok, we have approval, and will be working on an
upgradedbuild in the morning.
 

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

Well, if it’s our schema, 9.6 didn’t care about it, doesn’t mean there wasn’t one though, and I understand that
completely.

So, how do I go about capturing more information for the big brains (you guys) to help figure this out?  I have all our
resourcesat mine (and hence your) disposal.
 

> 
> 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.

Good, but the previous release of our product was at 9.6, so we’re currently using the pg_upgrade to do that, automated
(storageappliance).  Just talking out loud, that switching to 13.5 shouldn’t cause us any upgrade issues other than
figuringout builds and dependencies and some upgrade testing.  And a straight re-run with 13.5 on top of the db should
workjust fine.  When I talk out loud, I sometimes catch the stupid things I’m missing, and it allows others to point
outthe stupid things I’m missing...
 

Best,
Robert


В списке pgsql-performance по дате отправления:

Предыдущее
От: Robert Creager
Дата:
Сообщение: Re: Need help identifying a periodic performance issue.
Следующее
От: Thomas Munro
Дата:
Сообщение: Re: Need help identifying a periodic performance issue.