RE: Plans for solving the VACUUM problem

Поиск
Список
Период
Сортировка
От Don Baccus
Тема RE: Plans for solving the VACUUM problem
Дата
Msg-id 3.0.1.32.20010524111646.01776100@mail.pacifier.com
обсуждение исходный текст
Ответ на Plans for solving the VACUUM problem  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
At 10:00 AM 5/24/01 -0700, Mikheev, Vadim wrote:
>> >> Impractical ? Oracle does it.
>> >
>> >Oracle has MVCC?
>> 
>> With restrictions, yes.
>
>What restrictions? Rollback segments size?
>Non-overwriting smgr can eat all disk space...

Actually, the restriction I'm thinking about isn't MVCC related, per
se, but a within-transaction restriction.  The infamous "mutating table"
error.

>> You didn't know that?  Vadim did ...
>
>Didn't I mention a few times that I was
>inspired by Oracle? -:)

Yes, you most certainly have!



- Don Baccus, Portland OR <dhogaza@pacifier.com> Nature photos, on-line guides, Pacific Northwest Rare Bird Alert
Serviceand other goodies at http://donb.photo.net.
 


В списке pgsql-hackers по дате отправления:

Предыдущее
От: John Reid
Дата:
Сообщение: uml diagrams of system catalogues
Следующее
От: Martín Marqués
Дата:
Сообщение: Re: Re: OpenOffice compile