Re: index growth - Mailing list pgsql-general

From Tom Lane
Subject Re: index growth
Date
Msg-id 9137.1144598878@sss.pgh.pa.us
Whole thread Raw
In response to index growth  (Alex Mayrhofer <axelm@nona.net>)
Responses Re: index growth  (Alex Mayrhofer <axelm@nona.net>)
List pgsql-general
Alex Mayrhofer <axelm@nona.net> writes:
> i have a bunch of indices over rather frequently updated large tables. Those
> indices grow in size with the updates, so i frequently re-index them.

That usually shouldn't be necessary since PG 7.4 or so.  Do you have
some strange pattern of index key usage that is triggering index bloat,
or is this just a habit leftover from pre-7.4?

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: "Pg_restore -C" is not creating a database ( Was Create database bug in 8.1.3 ? )
Next
From: Gavin Hamill
Date:
Subject: Re: Load testing across 2 machines