Re: 8.2 pg_freespacemap crash - Mailing list pgsql-bugs

From Tom Lane
Subject Re: 8.2 pg_freespacemap crash
Date
Msg-id 16765.1239122007@sss.pgh.pa.us
Whole thread Raw
In response to 8.2 pg_freespacemap crash  (Dimitri Fontaine <dfontaine@hi-media.com>)
Responses Re: 8.2 pg_freespacemap crash  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
Dimitri Fontaine <dfontaine@hi-media.com> writes:
> Thanks to Andrew Gierth (irc:RhodiumToad) and after some analysis and  we've
> been able to understand what happened: MaxFSMPages is not the maximum number
> of elements (tables and indexes) contained into the FSM memory, and the
> contrib believes it is.

Hmm.  Actually the freespace.c code rounds that number up to the next
multiple of CHUNKPAGES:

    /* Allocate page-storage arena */
    nchunks = (MaxFSMPages - 1) / CHUNKPAGES + 1;

So your 2x patch is way overkill, but we do have an issue here.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: postgresql-8.3.6-1PGDG : redirect_stderr = on does not start server
Next
From: feridun türk
Date:
Subject: Backup -- Feridun Türk