ports.macports.org - sync broken?

[Arjun Salyan]

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

Thanks