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
Ответ на
Список
Дерево обсуждения
Re: Changing behavior of BEGIN...sleep...do something...COMMIT "Zeugswetter Andreas SB SD" <ZeugswetterA@spardat.at>
Re: Changing behavior of BEGIN...sleep...do something...COMMIT Bruce Momjian <pgman@candle.pha.pa.us>
Re: Changing behavior of BEGIN...sleep...do something...COMMIT Barry Lind <blind@xythos.com>
Re: Changing behavior of BEGIN...sleep...do something...COMMIT Tom Lane <tgl@sss.pgh.pa.us>
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 по дате отправления
От: Tom Lane
Дата: