Re: [ADMIN] Vacuum command

Поиск
Список
Период
Сортировка
От jwieck@debis.com (Jan Wieck)
Тема Re: [ADMIN] Vacuum command
Дата
Msg-id m0zoDcS-000EBQC@orion.SAPserv.Hamburg.dsh.de
обсуждение исходный текст
Ответ на Re: [ADMIN] Vacuum command  ("G. Anthony Reina" <reina@nsi.edu>)
Список pgsql-admin
>
> That makes sense. Is there a way that is less drastic than dumping,
> re-initdb, and reloading the database? It would probably take a day or
> two to do this. Does anybody know if I can fix the catalog in another
> way?
>
> -Tony

    Not any more. In earlier days, there was a reindexdb command,
    which used the  bootstrap  code  to  drop  and  recreate  the
    indices  for  the  system  catalog's.  But  that  disappeared
    sometime. I think there's  no  chance,  because  dropping  of
    catalog indices isn't allowed.


Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#======================================== jwieck@debis.com (Jan Wieck) #

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

Предыдущее
От: "G. Anthony Reina"
Дата:
Сообщение: Re: [ADMIN] Vacuum command
Следующее
От: Robert Honore
Дата:
Сообщение: Postgres on Digital UNIX 4.0D