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

Re: Replication Syatem

From: Chris Browne <cbbrowne(at)acm(dot)org>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Replication Syatem
Date: 2008-04-29 14:48:28
Message-ID: 60skx467k3.fsf@dba2.int.libertyrms.com (view raw or flat)
Thread:
Lists: pgsql-performance
meetgaurikanekar(at)gmail(dot)com ("Gauri Kanekar") writes:
> Basically we have some background process which updates "table1" and
> we don't want the application to make any changes to "table1" while
> vacuum.  Vacuum requires exclusive lock on "table1" and if any of
> the background or application is ON vacuum don't kick off. Thats the
> reason we need to get the site down.

VACUUM has not required an exclusive lock on tables since version 7.1.

What version of PostgreSQL are you running?
-- 
output = ("cbbrowne" "@" "acm.org")
http://linuxdatabases.info/info/sap.html
Rules of the Evil Overlord #192.  "If I appoint someone as my consort,
I will  not subsequently inform  her that she  is being replaced  by a
younger, more attractive woman.  <http://www.eviloverlord.com/>

In response to

pgsql-performance by date

Next:From: Vivek KheraDate: 2008-04-29 15:00:57
Subject: Re: Replication Syatem
Previous:From: Tom LaneDate: 2008-04-29 14:20:48
Subject: Re: Where do a novice do to make it run faster?

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