REINDEXing user table in non stand-alone?

Поиск
Список
Период
Сортировка
От Shuzo Kubo
Тема REINDEXing user table in non stand-alone?
Дата
Msg-id 9sddo6$1922$1@news.tht.net
обсуждение исходный текст
Ответы Re: REINDEXing user table in non stand-alone?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-admin
Hi,

I read the manual for the REINDEX command.
The REINDEX command is described as

    "Recover corrupted system indexes under
    stand-alone Postgres "

I am currently trying to reindex an user table.
Does one need to go into stand-alone mode to
reindex an user table?

I have actually REINDEXed an user table when
the database is not in stand-alone mode. It
seems fine but the test environment does not
have much users accessing it, the live site that
I eventually want to REINDEX does.

Is it safe to REINDEX an user table while in
non stand-alone mode when other users are
accessing it?

Thank you in advance.


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Problems with user-level security
Следующее
От: 00525@poffice.ccis.com.tw (franklin)
Дата:
Сообщение: what function likes M$SQL sp_helptext command in psql ???