Search Postgresql Archives

Re: index growth

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Alex Mayrhofer <axelm@xxxxxxxx> 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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux