On Sun, Feb 8, 2026 at 12:43 AM Durgamahesh Manne <maheshpostgres9@gmail.com> wrote:On Sun, 8 Feb, 2026, 10:59 Ron Johnson, <ronljohnsonjr@gmail.com> wrote:On Sat, Feb 7, 2026 at 11:19 PM Durgamahesh Manne <maheshpostgres9@gmail.com> wrote:HiHow much table bloat is acceptable before it affects performance in PostgreSQL? How big is the table? (For small tables, it doesn't matter.) How active is it? How frequently are records updated?--Death to <Redacted>, and butter sauce.Don't boil me, I'm still alive.<Redacted> lobster!HiTable size 100gbI use pgstattuple_approx to get Table bloat is about 16gb as of now since after repack is done on 27th of January Fillfactor already in placeIt's very critical application with updates on non partitioned table What did you set the fillfactor to?Have you minimized the number of indexes? (That lets HOT work better.)How long does it take to VACUUM the table?-- Death to <Redacted>, and butter sauce.Don't boil me, I'm still alive.<Redacted> lobster!
On Sun, 8 Feb, 2026, 10:59 Ron Johnson, <ronljohnsonjr@gmail.com> wrote:On Sat, Feb 7, 2026 at 11:19 PM Durgamahesh Manne <maheshpostgres9@gmail.com> wrote:HiHow much table bloat is acceptable before it affects performance in PostgreSQL? How big is the table? (For small tables, it doesn't matter.) How active is it? How frequently are records updated?--Death to <Redacted>, and butter sauce.Don't boil me, I'm still alive.<Redacted> lobster!HiTable size 100gbI use pgstattuple_approx to get Table bloat is about 16gb as of now since after repack is done on 27th of January Fillfactor already in placeIt's very critical application with updates on non partitioned table
On Sat, Feb 7, 2026 at 11:19 PM Durgamahesh Manne <maheshpostgres9@gmail.com> wrote:HiHow much table bloat is acceptable before it affects performance in PostgreSQL? How big is the table? (For small tables, it doesn't matter.) How active is it? How frequently are records updated?--Death to <Redacted>, and butter sauce.Don't boil me, I'm still alive.<Redacted> lobster!
HiHow much table bloat is acceptable before it affects performance in PostgreSQL?
pgsql-general by date:
Соглашаюсь с условиями обработки персональных данных
