Re: A long-running transaction

Поиск
Список
Период
Сортировка
От Joe
Тема Re: A long-running transaction
Дата
Msg-id 1176482556.782.83.camel@pampa
обсуждение исходный текст
Ответ на Re: A long-running transaction  (Andrew Sullivan <ajs@crankycanuck.ca>)
Ответы Re: A long-running transaction
Список pgsql-sql
Hi Andrew,

On Fri, 2007-04-13 at 07:49 -0400, Andrew Sullivan wrote:
> Because in the general case, you need the intermediate rows.  The
> problem is that you'd have to write a special piece of code to catch
> the case where nobody else can see the row that you're about to
> expire, and that test isn't free.  Therefore, you do it the same way
> any other row gets expired.

Just curious:  is there a way to defeat MVCC?  i.e., if you can lock the
database exclusively, there won't be any readers or writers?

Joe



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

Предыдущее
От: Andrew Sullivan
Дата:
Сообщение: Re: A long-running transaction
Следующее
От: Andrew Sullivan
Дата:
Сообщение: Re: A long-running transaction