Re: Multi-Versions and Vacuum - Mailing list pgsql-general

From grant
Subject Re: Multi-Versions and Vacuum
Date
Msg-id Pine.LNX.4.33.0207190917130.28033-100000@dbms.amadensor.com
Whole thread Raw
In response to Multi-Versions and Vacuum  (Anthony Berglas <anthony.berglas@lucida.com>)
Responses Re: Multi-Versions and Vacuum
List pgsql-general
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?

______________________________________________________________________________

                          Your mouse has moved.
       You must restart Windows for your changes to take effect.

#!/usr/bin/perl
print $i=pack(c5,(41*2),sqrt(7056),(unpack(c,H)-2),oct(115),10);



pgsql-general by date:

Previous
From: Stephane Bortzmeyer
Date:
Subject: Re: Looking for types: phone number, email addresses
Next
From: Jan Wieck
Date:
Subject: Re: Looking for types: phone number, email addresses