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