Re: [MASSMAIL]index bloat - fixed in which version

From: "Gilberto Castillo" <gilberto(dot)castillo(at)etecsa(dot)cu>
To: "Evan Rempel" <erempel(at)uvic(dot)ca>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: [MASSMAIL]index bloat - fixed in which version
Date: 2016-01-08 16:20:48
Message-ID: 51229.192.168.207.54.1452270048.squirrel@webmail.etecsa.cu
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?
>

Evan, you used vaccum?.

Rgds,
Gilberto Castillo
ETECSA, La Habana, Cuba

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Yogi Barot 2016-01-08 16:42:40 Pgadmin errors with postgresql 9.5
Previous Message Evan Rempel 2016-01-08 16:13:40 index bloat - fixed in which version