From: Gilberto Castillo <gilberto.castillo@etecsa.cu>
To: Evan Rempel <erempel@uvic.ca>
Cc: pgsql-admin@postgresql.org
Subject: Re: [MASSMAIL]index bloat - fixed in which version
Date: Fri, 8 Jan 2016 11:20:48 -0500 (GMT+5)
Message-ID: <51229.192.168.207.54.1452270048.squirrel@webmail.etecsa.cu> (raw)
In-Reply-To: <568FE034.7070702@uvic.ca>
References: <CAENQbUMxRHhLuz_FC-EPhuFRqJx=20hjqwuWvb4WT9D+QnzHPg@mail.gmail.com>
<CAG1_KcAdyso1wJKXGoqj0zLwfm6=EGNZErkqJtfVpMmjsbOsSw@mail.gmail.com>
<568FE034.7070702@uvic.ca>
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?
>
Evan, you used vaccum?.
Rgds,
Gilberto Castillo
ETECSA, La Habana, Cuba
--
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: gilberto.castillo@etecsa.cu, erempel@uvic.ca
Subject: Re: [MASSMAIL]index bloat - fixed in which version
In-Reply-To: <51229.192.168.207.54.1452270048.squirrel@webmail.etecsa.cu>
* 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