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

From: "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Changing behavior of BEGIN...sleep...do something...COMMIT
Date: 2003-03-31 18:06:08
Message-ID: Pine.LNX.4.33.0303311105310.12130-100000@css120.ihs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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?

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2003-03-31 18:21:02 Re: Changing behavior of BEGIN...sleep...do something...COMMIT
Previous Message ohp 2003-03-31 18:02:08 What's wrong