Re: Regarding fillfactor use case for only delete ops

Поиск
Список
Период
Сортировка
От Ron Johnson
Тема Re: Regarding fillfactor use case for only delete ops
Дата
Msg-id CANzqJaAyfk4BFEcSARByt=TinBLRWT8uPffEA9dY8qZ8bhsRGw@mail.gmail.com
обсуждение исходный текст
Ответ на Regarding fillfactor use case for only delete ops  (Durgamahesh Manne <maheshpostgres9@gmail.com>)
Ответы Re: Regarding fillfactor use case for only delete ops
Список pgsql-general
Дерево обсуждения
On Fri, Jun 6, 2025 at 4:36 AM Durgamahesh Manne <maheshpostgres9@gmail.com> wrote:
Hi  Team

Can we generate a fill factor for tables that have delete ops ?

Does the fill factor really work and help to minimize the bloat for tables that have delete ops?

I have parent table with weekly partitions So for every week 50 to 60 gb of bloat generates and autovacuum params already in place for child tables 

This confuses me.  It seems that you are deleting old data instead of just dropping the old partitions.

What did I misunderstand?

--
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!

В списке pgsql-general по дате отправления: