h situations, you should consider
>> using partitioning.
>>
>> And more closely to your question: I would not disable autovacuum but it
>> must not work with default values.
>>
>>
>>
>> Best regards
>>
>>
>>
>> *Michel SALAIS*
o
> *Envoyé :* vendredi 2 mai 2025 16:23
> *À :* pgsql-performance@lists.postgresql.org
> *Objet :* Vacuum Questions
>
>
>
> 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
>
-performance@lists.postgresql.org
Objet : Vacuum Questions
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
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
