Re: Replication Syatem

Поиск
Список
Период
Сортировка
От Chris Browne
Тема Re: Replication Syatem
Дата
Msg-id 60skx467k3.fsf@dba2.int.libertyrms.com
обсуждение исходный текст
Ответ на Replication Syatem  ("Gauri Kanekar" <meetgaurikanekar@gmail.com>)
Список pgsql-performance
meetgaurikanekar@gmail.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/>

В списке pgsql-performance по дате отправления:

Предыдущее
От: John Rouillard
Дата:
Сообщение: Re: Very poor performance loading 100M of sql data using copy
Следующее
От: Greg Smith
Дата:
Сообщение: Re: Very poor performance loading 100M of sql data using copy