Re: Changing behavior of BEGIN...sleep...do something...COMMIT

Поиск
Список
Период
Сортировка
От scott.marlowe
Тема Re: Changing behavior of BEGIN...sleep...do something...COMMIT
Дата
Msg-id Pine.LNX.4.33.0303311105310.12130-100000@css120.ihs.com
обсуждение исходный текст
Ответ на Changing behavior of BEGIN...sleep...do something...COMMIT  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Changing behavior of BEGIN...sleep...do something...COMMIT  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
On Fri, 28 Mar 2003, Tom Lane wrote:

> It seems to me that it'd be fairly easy to make BEGIN cause only
> a local state change in the backend; the actual transaction need not
> start until the first subsequent command is received.  It's already
> true that the transaction snapshot is not frozen at BEGIN time, but
> only when the first DML or DDL command is received; so this would
> have no impact on the client-visible semantics.  But a BEGIN-then-
> sleep-for-awhile client wouldn't interfere with VACUUM anymore.

What about serializable mode?  Wouldn't that break it?



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

Предыдущее
От: ohp@pyrenet.fr
Дата:
Сообщение: What's wrong
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Changing behavior of BEGIN...sleep...do something...COMMIT