Re: Emergency FBR: Lower concurrency on postgres to help load

2019-10-11 Thread Stephen John Smoogen
On Fri, 11 Oct 2019 at 12:10, Kevin Fenzi wrote: > > On Fri, Oct 11, 2019 at 09:52:20AM -0400, Stephen John Smoogen wrote: > > Currently the load on db-koji is 140+ and it is slow and > > non-responsive to users. I believe it is the below change which has > > affected this. I would like to lower

Re: Emergency FBR: Lower concurrency on postgres to help load

2019-10-11 Thread Kevin Fenzi
On Fri, Oct 11, 2019 at 09:52:20AM -0400, Stephen John Smoogen wrote: > Currently the load on db-koji is 140+ and it is slow and > non-responsive to users. I believe it is the below change which has > affected this. I would like to lower down io to 32 to see if that > affects things and tune

Re: Emergency FBR: Lower concurrency on postgres to help load

2019-10-11 Thread Clement Verna
On Fri, 11 Oct 2019 at 16:07, Pierre-Yves Chibon wrote: > On Fri, Oct 11, 2019 at 09:52:20AM -0400, Stephen John Smoogen wrote: > > Currently the load on db-koji is 140+ and it is slow and > > non-responsive to users. I believe it is the below change which has > > affected this. I would like to

Re: Emergency FBR: Lower concurrency on postgres to help load

2019-10-11 Thread Pierre-Yves Chibon
On Fri, Oct 11, 2019 at 09:52:20AM -0400, Stephen John Smoogen wrote: > Currently the load on db-koji is 140+ and it is slow and > non-responsive to users. I believe it is the below change which has > affected this. I would like to lower down io to 32 to see if that > affects things and tune

Emergency FBR: Lower concurrency on postgres to help load

2019-10-11 Thread Stephen John Smoogen
Currently the load on db-koji is 140+ and it is slow and non-responsive to users. I believe it is the below change which has affected this. I would like to lower down io to 32 to see if that affects things and tune further if needed. I am not doing this until Kevin or Patrick are around as it will