Re: No heap lookups on index

Поиск
Список
Период
Сортировка
От Christopher Kings-Lynne
Тема Re: No heap lookups on index
Дата
Msg-id 43CEE8FF.3050308@familyhealth.com.au
обсуждение исходный текст
Ответ на Re: No heap lookups on index  ("Jim C. Nasby" <jnasby@pervasive.com>)
Ответы Re: No heap lookups on index  ("Jim C. Nasby" <jnasby@pervasive.com>)
Re: No heap lookups on index  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: No heap lookups on index  (Rod Taylor <pg@rbt.ca>)
Список pgsql-hackers
> Oracle does, but you pay in other ways. Instead of keeping dead tuples
> in the main heap, they shuffle them off to an 'undo log'. This has some
> downsides:
> 
> Rollbacks take *forever*, though this usually isn't much of an issue
> unless you need to abort a really big transaction.

It's a good point though.  Surely a database should be optimised for the 
most common operation - commits, rather than rollbacks?

Chris



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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: No heap lookups on index
Следующее
От: "Jim C. Nasby"
Дата:
Сообщение: Re: No heap lookups on index