Re: index growth

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Alex Mayrhofer <axelm(at)nona(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: index growth
Date: 2006-04-09 16:07:58
Message-ID: 9137.1144598878@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Alex Mayrhofer <axelm(at)nona(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andrus 2006-04-09 16:38:30 Is difference between PostgreSQL and mySQL licences for client application minor only
Previous Message Tom Lane 2006-04-09 16:01:28 Re: "Pg_restore -C" is not creating a database ( Was Create database bug in 8.1.3 ? )