Re: ERROR: REINDEX DATABASE: Can be executed only on the currently open database.

Поиск
Список
Период
Сортировка
От Clodoaldo Pinto Neto
Тема Re: ERROR: REINDEX DATABASE: Can be executed only on the currently open database.
Дата
Msg-id 20040412030216.84003.qmail@web40906.mail.yahoo.com
обсуждение исходный текст
Ответ на Re: ERROR: REINDEX DATABASE: Can be executed only on the currently open database.  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: ERROR: REINDEX DATABASE: Can be executed only on the currently open database.  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
 --- Tom Lane <tgl@sss.pgh.pa.us> escreveu: >
> It's fairly unlikely that that is the solution you need.  How often do
> you vacuum this table?

A vacuum is executed every tree hours to the whole database after it is updated
with more than 300.000 inserts and deletes.

>  Does it participate in any foreign keys, or do
> you have any user-defined triggers on it?

It participates in two foreign keys. No ud triggers on it.

> > backend> reindex database KakaoStats
> > ERROR:  REINDEX DATABASE: Can be executed only on the currently open
> database.
>
> Double quotes would help here.
>
I will try it.


______________________________________________________________________

Yahoo! Messenger - Fale com seus amigos online. Instale agora!
http://br.download.yahoo.com/messenger/

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

Предыдущее
От: Ericson Smith
Дата:
Сообщение: Re: Large DB
Следующее
От: Tom Lane
Дата:
Сообщение: Re: REINDEX slow?