Re: Need help identifying a periodic performance issue.

2021-11-29 Thread Robert Creager
> On Nov 24, 2021, at 4:15 PM, Justin Pryzby wrote: > > This message originated outside your organization. > > On Wed, Nov 24, 2021 at 10:44:12PM +, Robert Creager wrote: >> I forgot, I had reloaded postgres, but had not re-started our app, so the >> connecti

Re: Need help identifying a periodic performance issue.

2021-11-24 Thread Robert Creager
I forgot, I had reloaded postgres, but had not re-started our app, so the connections wouldn’t have that plan setting on them. Re-doing now. On Nov 24, 2021, at 2:13 PM, Robert Creager mailto:robe...@spectralogic.com>> wrote: On Nov 19, 2021, at 11:47 AM, Robert Creager mailt

Re: Need help identifying a periodic performance issue.

2021-11-24 Thread Robert Creager
On Nov 19, 2021, at 11:47 AM, Robert Creager mailto:robe...@spectralogic.com>> wrote: On Nov 18, 2021, at 2:42 PM, Tom Lane mailto:t...@sss.pgh.pa.us>> wrote: This message originated outside your organization. Thomas Munro mailto:thomas.mu...@gmail.com>> writes: Thi

Re: Need help identifying a periodic performance issue.

2021-11-19 Thread Robert Creager
On Nov 18, 2021, at 2:42 PM, Tom Lane mailto:t...@sss.pgh.pa.us>> wrote: This message originated outside your organization. Thomas Munro mailto:thomas.mu...@gmail.com>> writes: This is all guesswork though, since we don't know quite what's happening on Robert's system. It might be worth sett

Re: Need help identifying a periodic performance issue.

2021-11-18 Thread Robert Creager
> On Nov 18, 2021, at 2:42 PM, Tom Lane wrote: > > This is all guesswork though, since we don't know quite what's > happening on Robert's system. It might be worth setting > "log_autovacuum_min_duration = 0" (either globally, or as a > reloption on the relevant tables), and seeing if there see

Re: Need help identifying a periodic performance issue.

2021-11-18 Thread Robert Creager
On Nov 18, 2021, at 2:08 PM, Thomas Munro mailto:thomas.mu...@gmail.com>> wrote: This message originated outside your organization. On Fri, Nov 19, 2021 at 6:03 AM Robert Creager mailto:robe...@spectralogic.com>> wrote: Which would be better? Discard plans or forcing custom p

Re: Need help identifying a periodic performance issue.

2021-11-18 Thread Robert Creager
> On Nov 17, 2021, at 10:42 PM, Justin Pryzby wrote: > > This message originated outside your organization. > > On Thu, Nov 18, 2021 at 04:39:42PM +1300, Thomas Munro wrote: >> On Thu, Nov 18, 2021 at 1:18 PM Robert Creager >> wrote: >>> So, how do I go

Re: Need help identifying a periodic performance issue.

2021-11-17 Thread Robert Creager
> On Nov 17, 2021, at 4:18 PM, Justin Pryzby wrote: > > This message originated outside your organization. > > On Wed, Nov 17, 2021 at 09:54:14PM +, Robert Creager wrote: > > We are able to move up to Postgres 13.5, in our ports tree, if that would > > help

Re: Need help identifying a periodic performance issue.

2021-11-17 Thread Robert Creager
On Nov 17, 2021, at 12:00 PM, Justin Pryzby mailto:pry...@telsasoft.com>> wrote: This message originated outside your organization. On Wed, Nov 17, 2021 at 05:51:05PM +, Robert Creager wrote: postgres`HeapTupleSatisfiesVisibility+0x42 postgres`heapgetpage

Re: Need help identifying a periodic performance issue.

2021-11-17 Thread Robert Creager
On Nov 17, 2021, at 10:51 AM, Robert Creager mailto:robe...@spectralogic.com>> wrote: On Nov 15, 2021, at 10:50 PM, Thomas Munro mailto:thomas.mu...@gmail.com>> wrote: This message originated outside your organization. On Tue, Nov 16, 2021 at 5:43 PM Robert Creager

Re: Need help identifying a periodic performance issue.

2021-11-16 Thread Robert Creager
On Nov 15, 2021, at 10:50 PM, Thomas Munro mailto:thomas.mu...@gmail.com>> wrote: This message originated outside your organization. On Tue, Nov 16, 2021 at 5:43 PM Robert Creager mailto:robe...@spectralogic.com>> wrote: One CPU is pegged, the data has been sent over STDIN, so Pos

Re: Need help identifying a periodic performance issue.

2021-11-16 Thread Robert Creager
On Nov 15, 2021, at 10:29 PM, Justin Pryzby mailto:pry...@telsasoft.com>> wrote: This message originated outside your organization. On Tue, Nov 16, 2021 at 04:43:25AM +, Robert Creager wrote: > We’re executing the following copy to fill a table with approximately 5k > r