Skip site navigation (1) Skip section navigation (2)

Re: Trouble-free vacuum w/concurrent writes? (was "PostgreSQL capabilities")

From: Charles Tassell <ctassell(at)isn(dot)net>
To: Ed Loehr <eloehr(at)austin(dot)rr(dot)com>, pgsql-general(at)hub(dot)org
Subject: Re: Trouble-free vacuum w/concurrent writes? (was "PostgreSQL capabilities")
Date: 2000-05-31 20:16:26
Message-ID: 4.2.0.58.20000531171416.009e3960@mailer.isn.net (view raw or flat)
Thread:
Lists: pgsql-general
No, that's now what he said.  You can backup the database while it's still 
being used (the pg_dmp runs in a transaction) but you still can't vacuum a 
database while it's in use.  Vacuuming is more along the lines of a defrag, 
it updates the indexes and maintains stats.

At 12:16 PM 5/31/00, Ed Loehr wrote:
>Bruce Momjian wrote:
> >
> > > Alex Pilosov wrote:
> > > >
> > > > > http://networkdna.com/database/index.html mentions that PostgreSQL is
> > > > > capable of "Online backup". What does that exactly mean?
> > > >
> > > > It means Postgres can do a reliable backup (a consistent snapshot) of a
> > > > database without shutting down the database.
> > >
> > > Hmmm.  My backup procedure, based on earlier discussions in this group,
> > > involves blocking all write-access during a pg_dump.  That is effectively
> > > shutting down the database from my perspective.  Is there a quicker way
> > > to take a consistent snapshot while still allowing writes?
> >
> > With 6.5 and 7.0, pg_dump grabs a consistent snapshot of the database at
> > the time it starts, and dumps that.  No reason to shut out users.
>
>Can other folks confirm that this is no longer a problem?  Are people
>successfully vacuuming while allowing full read/write access to the db?
>
>Regards,
>Ed Loehr


In response to

Responses

pgsql-general by date

Next:From: Bruce MomjianDate: 2000-05-31 20:27:24
Subject: PostgreSQL article in LinuxWorld
Previous:From: mikeoDate: 2000-05-31 18:41:17
Subject: TOP SESSIONS?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group