Re: Replication Syatem
От
Greg Smith
Тема
Re: Replication Syatem
Дата
Msg-id
Pine.GSO.4.64.0804290104570.2503@westnet.com
Ответ на
Re: Replication Syatem (Gauri Kanekar)
Список
Дерево обсуждения
Replication Syatem "Gauri Kanekar" <meetgaurikanekar@gmail.com>
Re: Replication Syatem "Peter Childs" <peterachilds@gmail.com>
Re: Replication Syatem "Gauri Kanekar" <meetgaurikanekar@gmail.com>
Re: Replication Syatem Brad Nicholson <bnichols@ca.afilias.info>
Re: Replication Syatem "Gauri Kanekar" <meetgaurikanekar@gmail.com>
Re: Replication Syatem Andrew Sullivan <ajs@commandprompt.com>
Re: Replication Syatem "Gauri Kanekar" <meetgaurikanekar@gmail.com>
Re: Replication Syatem "Pavan Deolasee" <pavan.deolasee@gmail.com>
Re: Replication Syatem Shane Ambler <pgsql@Sheeky.Biz>
Re: Replication Syatem Greg Smith <gsmith@gregsmith.com>
Re: Replication Syatem "Gauri Kanekar" <meetgaurikanekar@gmail.com>
Re: Replication Syatem Alvaro Herrera <alvherre@commandprompt.com>
Re: Replication Syatem Shane Ambler <pgsql@Sheeky.Biz>
Re: Replication Syatem "Gauri Kanekar" <meetgaurikanekar@gmail.com>
Re: Replication Syatem "Pavan Deolasee" <pavan.deolasee@gmail.com>
Re: Replication Syatem "Gauri Kanekar" <meetgaurikanekar@gmail.com>
Re: Replication Syatem "Pavan Deolasee" <pavan.deolasee@gmail.com>
Re: Replication Syatem "Heikki Linnakangas" <heikki@enterprisedb.com>
Re: Replication Syatem Craig Ringer <craig@postnewspapers.com.au>
Re: Replication Syatem "Heikki Linnakangas" <heikki@enterprisedb.com>
Re: Replication Syatem "Pavan Deolasee" <pavan.deolasee@gmail.com>
Re: Replication Syatem "Gauri Kanekar" <meetgaurikanekar@gmail.com>
Re: Replication Syatem Alvaro Herrera <alvherre@commandprompt.com>
Re: Replication Syatem "Pavan Deolasee" <pavan.deolasee@gmail.com>
Re: Replication Syatem "Gauri Kanekar" <meetgaurikanekar@gmail.com>
Re: Replication Syatem "Pavan Deolasee" <pavan.deolasee@gmail.com>
Re: Replication Syatem Gregory Stark <stark@enterprisedb.com>
Re: Replication Syatem Tom Lane <tgl@sss.pgh.pa.us>
Re: Replication Syatem Vivek Khera <vivek@khera.org>
Re: Replication Syatem salman <salmanb@quietcaresystems.com>
Re: Replication Syatem "Gauri Kanekar" <meetgaurikanekar@gmail.com>
Re: Replication Syatem Andrew Sullivan <ajs@commandprompt.com>
Re: Replication Syatem Greg Smith <gsmith@gregsmith.com>
Re: Replication Syatem "Radhika S" <radhika.sambamurti@gmail.com>
On Tue, 29 Apr 2008, Gauri Kanekar wrote: > 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. VACUUM FULL needs an exclusive lock, the regular one does not in 8.1. It's one of the reasons FULL should be avoided. If you do regular VACUUM frequently enough, you shouldn't ever need to do a FULL one anyway. -- * Greg Smith gsmith@gregsmith.com http://www.gregsmith.com Baltimore, MD
В списке pgsql-performance по дате отправления
