index bloat - fixed in which version

From: Evan Rempel <erempel(at)uvic(dot)ca>
To: pgsql-admin(at)postgresql(dot)org
Subject: index bloat - fixed in which version
Date: 2016-01-08 16:13:40
Message-ID: 568FE034.7070702@uvic.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

I have a database the has a huge amount of new and old deleted records (3 million a day). I remember reading somewhere that a particular version/update of postgresql reused deleted index entries so that the size of the index on disk did not grow indefinitely due to deleted index entries.

Can anyone provide a link to such a reverence, or at let me know which version(s) addressed the index bloat?

Thanks,

Evan.

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Gilberto Castillo 2016-01-08 16:20:48 Re: [MASSMAIL]index bloat - fixed in which version
Previous Message Keith Fiske 2016-01-08 16:07:41 Re: Partitioned Tables vs Vacuum+Reindex