Disabling indexes on a table
| От | John Scalia |
|---|---|
| Тема | Disabling indexes on a table |
| Дата | |
| Msg-id | 8D9636C9-D38E-4857-A542-1469A11A25FF@gmail.com обсуждение исходный текст |
| Ответы |
Re: Disabling indexes on a table
Re: Disabling indexes on a table |
| Список | pgsql-admin |
One of my developers asked me about this, and he suggested running the following update: UPDATE pg_index SET indisready=false WHERE indrelid = (select oid from pg_class where release = ‘his_table’); I told him it’s never a good idea to update anything in a system catalog by hand, but that I would reach out here for a betteropinion. Am I correct that he shouldn’t try this, or is he OK to do this? His table has approximately 8 different indexeson it, and those really slow down his bulk loads. Usually when I have to get involved, I just drop his indexes andrebuild them afterwards, and I know that is always safe. — Jay Sent from my iPad
В списке pgsql-admin по дате отправления: