Postgres Pro
Downloads
Home   >   mailing lists

Re: [HACKERS] The number of bytes is stored in index_size of pgstatindex() ? - Mailing list pgsql-docs

From Peter Geoghegan
Subject Re: [HACKERS] The number of bytes is stored in index_size of pgstatindex() ?
Date
Msg-id CAM3SWZR5X+8QbUUh2xUuNJ8gPe7cm9Lr9CtEQafxkJoqQn-7+g@mail.gmail.com
Whole thread Raw
In response to Re: [HACKERS] The number of bytes is stored in index_size of pgstatindex() ?  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: [HACKERS] The number of bytes is stored in index_size of pgstatindex() ?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-docs
Tree view 
On Thu, Feb 18, 2016 at 4:15 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Because they've been removed from the right-link/left-link chains.

That isn't the same thing as being inaccessible by scans, clearly
(just what you call the "leaf scan sequence"). Besides, half-dead
pages still have right-link/left-link chains, and there are usage
patterns where half-dead pages might accumulate.


--
Peter Geoghegan

pgsql-docs by date:

Previous
From: Bruce Momjian
Date:
Subject: effective_io_concurrency and SSDs
Next
From: Tom Lane
Date:
Subject: Re: [HACKERS] The number of bytes is stored in index_size of pgstatindex() ?