Re: Multi-Versions and Vacuum

Поиск
Список
Период
Сортировка
От grant
Тема Re: Multi-Versions and Vacuum
Дата
Msg-id Pine.LNX.4.33.0207190917130.28033-100000@dbms.amadensor.com
обсуждение исходный текст
Ответ на Multi-Versions and Vacuum  (Anthony Berglas <anthony.berglas@lucida.com>)
Ответы Re: Multi-Versions and Vacuum  (Bruce Momjian <pgman@candle.pha.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Stephane Bortzmeyer
Дата:
Сообщение: Re: Looking for types: phone number, email addresses
Следующее
От: Jan Wieck
Дата:
Сообщение: Re: Looking for types: phone number, email addresses