pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Bruno Wolff III <bruno@wolff.to>
To: Jaime Casanova <systemguards@gmail.com>
Cc: Chris Hoover <revoohc@gmail.com>
Cc: Michael Fuhr <mike@fuhr.org>
Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: What happens to transactions durring a pg_dump?
Date: Sat, 21 Jan 2006 18:25:19 -0600
Message-ID: <20060122002519.GA20969@wolff.to> (raw)
In-Reply-To: <c2d9e70e0601091222y64e49593lc6f9d7809a05444b@mail.gmail.com>
References: <1d219a6f0601090922s5224e78emd68cf850b836c2af@mail.gmail.com>
	<20060109174511.GA43775@winnie.fuhr.org>
	<1d219a6f0601091000u45439e1dq1eb8296e8ffa3dba@mail.gmail.com>
	<c2d9e70e0601091222y64e49593lc6f9d7809a05444b@mail.gmail.com>

On Mon, Jan 09, 2006 at 15:22:09 -0500,
  Jaime Casanova <systemguards@gmail.com> wrote:
> On 1/9/06, Chris Hoover <revoohc@gmail.com> wrote:
> >
> > Just to make sure I correctly understood what I read, once pg_dump issues
> > the :
> > BEGIN
> > SET TRANSACTION ISOLATION LEVEL SERIALIZABLE
> >
> > The backup will only see transactions that were commited before the
> > isolation level was set Is this correct?  Any transactions that are commited
> > while the backup is running are not seen by pg_dump.
> >
> > Correct?
> >
> > Thanks,
> >
> > Chris
> >
> 
> correct

I don't think that is precisely correct. I believe that the snapshot isn't
set until the first query is made within the transaction. In practice
this won't be too much of a difference for pg_dump. But if you were entering
the commands interactively and there was a long delay between the SET
command and the first query, the difference might be significant.

I found a comment on this at:
http://64.233.167.104/search?q=cache:1QgAKZwFxK8J:www.sai.msu.su/~megera/postgres/gist/papers/concur...



view thread (7+ messages)  latest in thread

Message-ID: <20060122002519.GA20969@wolff.to>
Permalink:  ../20060122002519.GA20969@wolff.to/
Also on:    postgresql.org/message-id/20060122002519.GA20969@wolff.to

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: bruno@wolff.to, systemguards@gmail.com, revoohc@gmail.com, mike@fuhr.org
  Subject: Re: What happens to transactions durring a pg_dump?
  In-Reply-To: <20060122002519.GA20969@wolff.to>
  References: <1d219a6f0601090922s5224e78emd68cf850b836c2af@mail.gmail.com> <20060109174511.GA43775@winnie.fuhr.org> <1d219a6f0601091000u45439e1dq1eb8296e8ffa3dba@mail.gmail.com> <c2d9e70e0601091222y64e49593lc6f9d7809a05444b@mail.gmail.com> <20060122002519.GA20969@wolff.to>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox