Re: What happens to transactions durring a pg_dump?
От | Bruno Wolff III |
---|---|
Тема | Re: What happens to transactions durring a pg_dump? |
Дата | |
Msg-id | 20060122002519.GA20969@wolff.to обсуждение исходный текст |
Ответ на | Re: What happens to transactions durring a pg_dump? (Jaime Casanova <systemguards@gmail.com>) |
Ответы |
Re: What happens to transactions durring a pg_dump?
|
Список | pgsql-admin |
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/concurrency/concurrency.pdf+postgres+snapshot+set+serializable&hl=en
В списке pgsql-admin по дате отправления: