Postgres Pro
Downloads
Home   >   mailing lists

Re: full db locking during dump - Mailing list pgsql-general

From Tom Lane
Subject Re: full db locking during dump
Date
Msg-id 19670.1073615248@sss.pgh.pa.us
Whole thread Raw
In response to full db locking during dump  (Gregory Stone <guomo@yahoo.com>)
List pgsql-general
Tree view 
Gregory Stone <guomo@yahoo.com> writes:
> I have a situation where I am doing a pg_dump from my database. I want to
> make sure that noone is inserting into the tables being dump during the
> dump. Does the MVCC architecture make it a moot point

It's moot.  You get a consistent snapshot as of the dump start time,
regardless.

            regards, tom lane

pgsql-general by date:

Previous
From: Oleg Bartunov
Date:
Subject: Re: website doc search is extremely SLOW
Next
From: "Glenn Wiorek"
Date:
Subject: Re: [HACKERS] Announce: Search PostgreSQL related resources