Skip to content

Instantly share code, notes, and snippets.

@jonashaag

jonashaag/disable_index.sql

Last active September 2, 2022 07:34
Show Gist options
  • Save jonashaag/54a1cf6c5c5f6bd7f4c87c9ad8260db1 to your computer and use it in GitHub Desktop.
Save jonashaag/54a1cf6c5c5f6bd7f4c87c9ad8260db1 to your computer and use it in GitHub Desktop.
Download ZIP
PostgreSQL temporarily disable index
Raw
disable_index.sql
UPDATE pg_index
SET indisready=false, indisvalid=false
WHERE indrelid = (SELECT oid FROM pg_class WHERE relname='<TABLE_NAME>');
... do work ...
REINDEX TABLE "<TABLE_NAME>";
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment