On Fri, May 2, 2025 at 9:23 PM Leo wrote:
> I am purging old records from a table (500 million rows, but I am doing it in
> sets of 50,000,000 with a smaller loop of 100,000). That works just fine.
>
> Because of the amount of data/rows deleted, I disabled the autovacuum for
> this table (I w
Also, is there a way to estimate the vacuum execution? Something like
explain plan - without actually vacuuming, just to see how it will perform
it - like a degree of parallelism?
On Fri, May 2, 2025 at 10:23 AM Leo wrote:
> I have been working on AWS PostgreSQL RDS for a few years, but still n
I have been working on AWS PostgreSQL RDS for a few years, but still not
very experienced when it comes to performance issues. Plus RDS is slightly
different from the pure PostgreSQL.
I am trying to comprehend exactly how vacuum works.
Here is what I am trying to do.
I am purging old records fr
