VACUUMing a live site OK?

Поиск
Список
Период
Сортировка
От Shuzo Kubo
Тема VACUUMing a live site OK?
Дата
Msg-id 9qmuld$uma$1@news.tht.net
обсуждение исходный текст
Ответы Re: VACUUMing a live site OK?
Список pgsql-admin
Hi,

I have a web application using PostgreSQL 7.1.3 with a table that
experiences alot of UPDATEs. I shouldn't be updating the data so much to
start off with but can no longer avoid the situation.

I would like to vacuum a table (1 table only) to maintain an acceptable
performance. Is it safe to vacuum a table when users are attempting to
SELECT from or UPDATE to it? I would imagine that the table would get locked
and there should be no problems.

Any help is greatly appreciated. Thank you very much in advance.


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

Предыдущее
От: Giles Constant
Дата:
Сообщение: Re: Mirroring with WAL?
Следующее
От: Brian McCane
Дата:
Сообщение: Re: Please help - tks