ports.macports.org - sync broken?
arjun at macports.org
Sat Oct 30 09:51:25 UTC 2021
> On 27-Oct-2021, at 5:32 PM, Christopher Nielsen <mascguy at rochester.rr.com> 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.
More information about the macports-dev