> On 27-Oct-2021, at 5:32 PM, Christopher Nielsen <[email protected]>
> wrote:
>
> Thanks Arjun, looking much better now.
>
> One other observation though: Prior to this, the “Maintained by Me” and
> “Watched by Me” pages were incredibly responsive, and would refresh/update
> almost instantly. Now, however, it seems to take up to 10 seconds on a
> refresh.
>
> Initially I chalked it up to the site warming up, after the fix was initially
> released. But a few days later, that’s still the case. Has something changed,
> to cause a slowdown?
Right, it went too slow. The builds table is becoming very large and I believe
after the `ALTER` we did to fix the syncing might have had increased the
obsolete data. Doing a VACUUM ANALYZE of the builds table has brought back
performance to normal.
I will setup aggressive auto-vacuum for this table.
Thanks
