Christophe <xof(at)thebuild(dot)com> writes:
> Given this, is there is a recommended way of detecting bloat in
> indices automatically, rather than just looking at them once in a
> while and saying, "Hm, that looks pretty big"?
contrib/pgstattuple works; it's just too expensive to run every
few minutes ...
regards, tom lane
In response to
pgsql-general by date
|Next:||From: Jeff Davis||Date: 2009-05-28 00:54:27|
|Subject: Re: What is the right way to deal with a table with rows
that are not in a random order?|
|Previous:||From: Christophe||Date: 2009-05-27 23:59:42|
|Subject: Re: Bloated Table |