Re: heap metapages - Mailing list pgsql-hackers

From Stephen Frost
Subject Re: heap metapages
Date
Msg-id 20120521191524.GG1267@tamriel.snowman.net
Whole thread Raw
In response to Re: heap metapages  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: heap metapages
List pgsql-hackers
* Robert Haas (robertmhaas@gmail.com) wrote:
> The FSM and VM are small enough
> that interleaving them with the actual data probably wouldn't slow
> down seq scans materially.

Wouldn't that end up potentially causing lots of random i/o if you need
to look at many parts of the FSM or VM..?

Also, wouldn't having it at the start of the heap reduce the changes
needed to the SM?  Along with make such things easier to find
themselves, when talking about forensics?

Of course, the real challenge here is dealing with such an on-disk
format change...  If we were starting from scratch, I doubt there would
be much resistance, but figuring out how to do this and still support
pg_upgrade could be quite ugly.
Thanks,
    Stephen

pgsql-hackers by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: [BUGS] 9.2beta1 regression: pg_restore --data-only does not set sequence values any more
Next
From: Simon Riggs
Date:
Subject: Re: heap metapages