Re: Options for more aggressive space reclamation in vacuuming?

From: Peter Geoghegan <pg(at)bowt(dot)ie>
To: Wells Oliver <wells(dot)oliver(at)gmail(dot)com>
Cc: Jeff Janes <jeff(dot)janes(at)gmail(dot)com>, pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Options for more aggressive space reclamation in vacuuming?
Date: 2023-05-15 00:34:05
Message-ID: CAH2-WzkoKeN0pACuQLNoMGwick9t2_4rJq4kqyYJNjwM74nv5w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Sun, May 14, 2023 at 2:03 PM Wells Oliver <wells(dot)oliver(at)gmail(dot)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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Nikhil Ingale 2023-05-15 05:26:09 Re: Find out the indexed columns
Previous Message Paul Smith 2023-05-14 23:11:27 Re: Options for more aggressive space reclamation in vacuuming?