Re: Automatic free space map filling
Tom Lane <tgl@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Peter Eisentraut <peter_e@gmx.net>
Cc: pgsql-hackers@postgresql.org
Date: 2006-03-01T17:41:01Z
Lists: pgsql-hackers
Peter Eisentraut <peter_e@gmx.net> writes: > Tom Lane wrote: >> How does an optimistic FSM entry avoid the need to run vacuum? > It ensures that all freed tuples are already in the FSM. That has nothing to do with it, because the space isn't actually free for re-use until vacuum deletes the tuple. regards, tom lane