On Wed, 9 Apr 2025 at 13:09, Kevin Fenzi via infrastructure < infrastructure@lists.fedoraproject.org> wrote:
> Trying to answer everyone... ;) > > > Well, thats... the entire table. Most of the time there's no bounce > events to process, or only 1-2. > > I worry there that just deleting them, but leaving the table might cause > postgresql to have bloated indexes or the like even tho the table is now > pretty small? But I guess a vacuum full would fix that. > > I also don't understand why they are keeping these... is there some > historical value in knowning about a bounce 5 years ago? > > So I would recommend scrubbing that table. When we were looking at the upgrade to mailman3 this was a table which was listed by upstream as needing manual cleaning if you did the upgrade. The problem was that it killed performance as it tries to work its way through the ginormous table and remove people who have bounced too much. When we looked at this in 2020, there were multiple reports from other users of upgrading mailman3 to newest that they lost half their membership weeks after the upgrade because the bounce table had finally gotten whatever usage count it needed to do and cleaned out what were considered bad accounts. It didn't matter if the bounce was 2 years ago and 6 months ago. That was enough to consider it a removal for bounces. They may have fixed that part eventually, but I would expect it to still cause issues at that size. [I am assuming here that this is the issue I marked back then as MUST BE DONE during the upgrade and not some other one which caused similar problems from the large bounce table.] -- Stephen Smoogen, Red Hat Automotive Let us be kind to one another, for most of us are fighting a hard battle. -- Ian MacClaren
-- _______________________________________________ infrastructure mailing list -- infrastructure@lists.fedoraproject.org To unsubscribe send an email to infrastructure-le...@lists.fedoraproject.org Fedora Code of Conduct: https://docs.fedoraproject.org/en-US/project/code-of-conduct/ List Guidelines: https://fedoraproject.org/wiki/Mailing_list_guidelines List Archives: https://lists.fedoraproject.org/archives/list/infrastructure@lists.fedoraproject.org Do not reply to spam, report it: https://pagure.io/fedora-infrastructure/new_issue
