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 по дате отправления: