From: Evan Rempel <erempel@uvic.ca>
To: pgsql-admin@postgresql.org
Subject: index bloat - fixed in which version
Date: Fri, 8 Jan 2016 08:13:40 -0800
Message-ID: <568FE034.7070702@uvic.ca> (raw)
In-Reply-To: <CAG1_KcAdyso1wJKXGoqj0zLwfm6=EGNZErkqJtfVpMmjsbOsSw@mail.gmail.com>
References: <CAENQbUMxRHhLuz_FC-EPhuFRqJx=20hjqwuWvb4WT9D+QnzHPg@mail.gmail.com>
<CAG1_KcAdyso1wJKXGoqj0zLwfm6=EGNZErkqJtfVpMmjsbOsSw@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-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.
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: erempel@uvic.ca
Subject: Re: index bloat - fixed in which version
In-Reply-To: <568FE034.7070702@uvic.ca>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox