Peter Geoghegan wrote: > On Thu, Feb 18, 2016 at 4:53 PM, Tom Lane <t...@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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
