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@candle.pha.pa.us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026