On Sun, Feb 8, 2026 at 12:43 AM Durgamahesh Manne <[email protected]> wrote:
> On Sun, 8 Feb, 2026, 10:59 Ron Johnson, <[email protected]> wrote: > >> On Sat, Feb 7, 2026 at 11:19 PM Durgamahesh Manne < >> [email protected]> wrote: >> >>> Hi >>> >>> How 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! >> > > > Hi > > Table size 100gb > I 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 place > It'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!
