Re: Free-space-map management thoughts - Mailing list pgsql-hackers

From Matthew T. O'Connor
Subject Re: Free-space-map management thoughts
Date
Msg-id 008f01c2dde7$ccf81730$6d00a8c0@sales4
Whole thread Raw
In response to Free-space-map management thoughts  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Free-space-map management thoughts
List pgsql-hackers
> PS: Another idea I'm toying with is to dump out the FSM contents at
> postmaster shutdown and reload them at restart, so that the FSM doesn't
> have to start from ground zero on every restart cycle.  But that's
> independent of the management algorithm...

Correct me if I'm wrong, but the FSM is only populated by vacuum, so there
is no FSM information for any given table / database until it's vacuumed, in
a long running production enviornment this may not be that important, but it
could result in a large increase in file size any time the database is
restarted.

I think this change, while independent of your proposal, is important.



pgsql-hackers by date:

Previous
From: "James H. Cloos Jr."
Date:
Subject: ecpg in REL7_3_2
Next
From: Larry Rosenman
Date:
Subject: Re: ecpg in REL7_3_2