From: Alvaro Herrera <alvherre@2ndquadrant.com>
To: Peter Geoghegan <pg@heroku.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: 大塚憲司 <otsuka.kenji@nttcom.co.jp>
Cc: pgsql-docs@postgresql.org, Pg Hackers <pgsql-hackers@postgresql.org>
Subject: Re: [DOCS] The number of bytes is stored in index_size of pgstatindex() ?
Date: Fri, 19 Feb 2016 17:05:44 -0300
Message-ID: <20160219200544.GA137983@alvherre.pgsql> (raw)
In-Reply-To: <CAM3SWZQofb+vrCn2Xb9HVDfesWVEE7S3Q_xmriaAMfjbCJYPtQ@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-hackers>
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
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-docs@postgresql.org
Cc: alvherre@2ndquadrant.com, pg@heroku.com, tgl@sss.pgh.pa.us, otsuka.kenji@nttcom.co.jp, pgsql-hackers@postgresql.org
Subject: Re: [DOCS] The number of bytes is stored in index_size of pgstatindex() ?
In-Reply-To: <20160219200544.GA137983@alvherre.pgsql>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox