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