One additional point about reindexing I should have mentioned, make sure
you have adequate disk space to complete the reindexing.
Craig
On Mon, May 5, 2025 at 8:33 AM Craig Jackson
wrote:
> For the two indexes that take 12 hours to vacuum: If you can drop and
> rebuild them in less than the 12
For the two indexes that take 12 hours to vacuum: If you can drop and
rebuild them in less than the 12 hours it takes to vacuum them and you can
have them be offline then I would do that. If you can't take the indexes
offline then consider reindexing online.
Also, if the indexes aren't needed for
Hi
It is not your question but for such 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
De : Leo
Envoyé : vendredi 2 mai 2025 16:23
À : pgsql-
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
