Reindex doesn't eliminate bloat

From: Ron Johnson <ron(dot)l(dot)johnson(at)cox(dot)net>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Reindex doesn't eliminate bloat
Date: 2018-03-12 22:05:03
Message-ID: 8ba3c6c1-709b-d853-97f0-9ef458528b3d@cox.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

v8.4.12

According to this (https://pastebin.com/TJB32n5M) query, which I thought I
got from https://wiki.postgresql.org/wiki/Index_Maintenance, a list of
indexes and their bloat is generated.

After reindexing a table with a large amount of reported bloat (column
bloat_pct says 29%), re-running the query shows no change in the amount of
bloat.  This is a historical table, and VACUUM VERBOSE shows that there's
nothing to free up.

Is this something that I must live with, or am I misinterpreting the query?

Thanks,

--
Angular momentum makes the world go 'round.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Nikolay Samokhvalov 2018-03-12 22:20:55 Re: Reindex doesn't eliminate bloat
Previous Message Andreas Joseph Krogh 2018-03-12 20:18:22 Logical decoding on standby