Re: Regarding fillfactor use case for only delete ops
| От | Ron Johnson |
|---|---|
| Тема | Re: Regarding fillfactor use case for only delete ops |
| Дата | |
| Msg-id | CANzqJaB8aRCuEYYDU_qK0WUVVdWdoCte=wDt5387uj=Ncw5_Pg@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Regarding fillfactor use case for only delete ops (Laurenz Albe <laurenz.albe@cybertec.at>) |
| Ответы |
Re: Regarding fillfactor use case for only delete ops
Re: Regarding fillfactor use case for only delete ops |
| Список | pgsql-general |
On Fri, Jun 6, 2025 at 8:57 AM Laurenz Albe <laurenz.albe@cybertec.at> wrote:
On Fri, 2025-06-06 at 14:10 +0530, Durgamahesh Manne wrote:
> 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
Nothing can ever avoid bloat caused by DELETE, except partitioning in a
way that you can drop a partition rather than running DELETE.
Laurenz,
Isn't the fill factor aimed at reducing bloat during updates of HOT tables?
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!
В списке pgsql-general по дате отправления: