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")
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 Khera||Date: 2008-04-29 15:00:57|
|Subject: Re: Replication Syatem |
|Previous:||From: Tom Lane||Date: 2008-04-29 14:20:48|
|Subject: Re: Where do a novice do to make it run faster? |