On 10/10/19 4:57 PM, Orion Poplawski wrote:
On 10/10/19 9:23 AM, Kevin Fenzi wrote:
> On Thu, Oct 10, 2019 at 03:30:40PM +0200, Robert-André Mauchin wrote:
>> On Thursday, 10 October 2019 04:42:57 CEST Orion Poplawski wrote:
>>> Anyone else seeing this? If so, anyone know the reason and plans to
>>> fix? Thanks!
>>
>> I concur, yesterday it was taking around a minute to get an answer
>> from the
>> server.
>
> Pretty please can you all indicate approximately when (UTC) you were
> seeing the slowness? I suspect it may be the nightly database dump job,
> but I can't tell without knowing when you saw the slowness...
>
> I did a bunch of work recently to make it faster... but that seems to
> have made the db dump cause it to be much slower.
>
> This includes bumping the memory on the vm from 32gb to 120gb,
> increasing postgresql's shared_buffers to 48G and effective_cache size
> to 32GB.
>
> I just killed the dump that was running.
> Can you all confirm it's much faster after 15:15UTC?
>
> If indeed it's the dump, will try and figure out a way to tune it
> better.
Thanks, it is much better now. I feel like I've hit periods of slowness
over several days recently so I will definitely note times if I run into
it again.
Definitely slower again:
Fri Oct 11 02:20:53 UTC 2019
--
Orion Poplawski
Manager of NWRA Technical Systems 720-772-5637
NWRA, Boulder/CoRA Office FAX: 303-415-9702
3380 Mitchell Lane orion(a)nwra.com
Boulder, CO 80301
https://www.nwra.com/