Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Replication Syatem
- From: Chris Browne <cbbrowne(at)acm(dot)org>
- To: pgsql-performance(at)postgresql(dot)org
- Subject: Re: Replication Syatem
- Date: Tue, 29 Apr 2008 10:48:28 -0400
- Message-id: <60skx467k3(dot)fsf(at)dba2(dot)int(dot)libertyrms(dot)com>
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/>
- References:
- Replication Syatem
- From: Gauri Kanekar
- Re: Replication Syatem
- From: Chris Browne
- Re: Replication Syatem
- From: Gauri Kanekar
- Replication Syatem
- Prev by Date: Re: Very poor performance loading 100M of sql data using copy
- Next by Date: Re: Very poor performance loading 100M of sql data using copy
- Previous by thread: Re: Replication Syatem
- Next by thread: Where do a novice do to make it run faster?
- Indexes: