Postgres Pro
Downloads
Home   >   mailing lists

Re: FSM corruption leading to errors - Mailing list pgsql-hackers

From Pavan Deolasee
Subject Re: FSM corruption leading to errors
Date
Msg-id CABOikdMfdiYAkdRZRQLB_JJViWrap6x_3ArONra7dP5WfYq3OA@mail.gmail.com
Whole thread Raw
In response to Re: FSM corruption leading to errors  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tree view


On Mon, Oct 24, 2016 at 9:47 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:


Also, we could at least discount the FSM root page and first intermediate
page, no?  That is, the upper limit could be

        pg_relation_size(oid::regclass, 'fsm') / 2 - 2*current_setting('block_size')::BIGINT


+1 for doing that.

Thanks,
Pavan

--
 Pavan Deolasee                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services

pgsql-hackers by date:

Previous
From: Albe Laurenz
Date:
Subject: Re: Add PGDLLEXPORT to PG_FUNCTION_INFO_V1
Next
From: Jonathan Katz
Date:
Subject: Press Release Draft - 2016-10-27 Cumulative Update