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