Re: Multi-Versions and Vacuum

grant wrote:
> If Oracle uses multiple version concurrency, then why does it appear to do
> row locking (I use Oracle at work, but I do not admin it)
>
> The only downside I have seen to MVCS is the extra disk space, but with
> the performance improvements in a highly concurrent use environment, it is
> well worth it.
>
> Q: Does VACUUM FULL remove the rows that are too many for the FSM? Or,
> are they just stuck? I know that regular VACUUM will not allow reuse of
> overflowed rows. Also, how does one calculate the propper size for the
> FSM?

VACUUM full removes all unused rows from disk _including_ ones that
aren't in the free space map.

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026