Re: 8.2 pg_freespacemap crash

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Dimitri Fontaine <dfontaine(at)hi-media(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: 8.2 pg_freespacemap crash
Date: 2009-04-07 16:33:27
Message-ID: 16765.1239122007@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Dimitri Fontaine <dfontaine(at)hi-media(dot)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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message feridun türk 2009-04-07 18:02:14 Backup -- Feridun Türk
Previous Message Tom Lane 2009-04-07 14:31:01 Re: postgresql-8.3.6-1PGDG : redirect_stderr = on does not start server