pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedindex bloat - fixed in which version
2+ messages / 2 participants
[nested] [flat]
* index bloat - fixed in which version
@ 2016-01-08 16:13 Evan Rempel <erempel@uvic.ca>
0 siblings, 1 reply; 2+ messages in thread
From: Evan Rempel @ 2016-01-08 16:13 UTC (permalink / raw)
To: 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.
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: [MASSMAIL]index bloat - fixed in which version
@ 2016-01-08 16:20 Gilberto Castillo <gilberto.castillo@etecsa.cu>
parent: Evan Rempel <erempel@uvic.ca>
0 siblings, 0 replies; 2+ messages in thread
From: Gilberto Castillo @ 2016-01-08 16:20 UTC (permalink / raw)
To: Evan Rempel <erempel@uvic.ca>; +Cc: 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
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2016-01-08 16:20 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2016-01-08 16:13 index bloat - fixed in which version Evan Rempel <erempel@uvic.ca>
2016-01-08 16:20 ` Gilberto Castillo <gilberto.castillo@etecsa.cu>
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