Re: Options for more aggressive space reclamation in vacuuming?

Поиск
Список
Период
Сортировка
От Peter Geoghegan
Тема Re: Options for more aggressive space reclamation in vacuuming?
Дата
Msg-id CAH2-WzkoKeN0pACuQLNoMGwick9t2_4rJq4kqyYJNjwM74nv5w@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Options for more aggressive space reclamation in vacuuming?  (Wells Oliver <wells.oliver@gmail.com>)
Список pgsql-admin
Дерево обсуждения 
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 по дате отправления:

Предыдущее
От: Paul Smith
Дата:
Сообщение: Re: Options for more aggressive space reclamation in vacuuming?
Следующее
От: Nikhil Ingale
Дата:
Сообщение: Re: Find out the indexed columns