Re: [HACKERS] The number of bytes is stored in index_size of pgstatindex() ?

Peter Geoghegan wrote:
> On Thu, Feb 18, 2016 at 4:53 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:

> >> there are usage patterns where half-dead pages might accumulate.
> >
> > Other than a usage pattern of "randomly SIGKILL backends every few
> > seconds", I don't see how that would happen.
>
> I meant where pages could accumulate without being recycled.

But those pages are supposed to be used as the index grows.  So unless
they are forgotten by the FSM, they shouldn't accumulate.  (Except where
the table doesn't grow but only shrinks, so there's no need for new
index pages, but I don't think that's an interesting case.)

--
Álvaro Herrera                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services