Postgres Pro
Downloads
Home   >   mailing lists

Re: Options for more aggressive space reclamation in vacuuming? - Mailing list pgsql-admin

From Peter Geoghegan
Subject Re: Options for more aggressive space reclamation in vacuuming?
Date
Msg-id CAH2-WzkoKeN0pACuQLNoMGwick9t2_4rJq4kqyYJNjwM74nv5w@mail.gmail.com
Whole thread Raw
In response to Re: Options for more aggressive space reclamation in vacuuming?  (Wells Oliver <wells.oliver@gmail.com>)
List pgsql-admin
Tree view 
On Sun, May 14, 2023 at 2:03 PM Wells Oliver <wells.oliver@gmail.com> wrote:
> I think our use-case here is nothing special: just very large tables that are deleted from and re-inserted with some
frequency.

What Postgres version are you using?

If you're not on a more recent version, but upgrade (ideally to 14 or
15) then you may find the index bloat situation to be much improved.

--
Peter Geoghegan

pgsql-admin by date:

Previous
From: Paul Smith
Date:
Subject: Re: Options for more aggressive space reclamation in vacuuming?
Next
From: Nikhil Ingale
Date:
Subject: Re: Find out the indexed columns