Indexing
Why indexing¶
Makes reads faster
[[PSQL Query Optimization]]¶
Creating¶
Name is max 63 chars
Reindex vs dropping and creating¶
REINDEX
locks writes, but not reads.
DROP INDEX
locks writes and reads, then CREATE INDEX
locks writes only.
CREATE INDEX CONCURRENTLY
- DROP old index
-
rename new index as the original name
-
Longer build time
- minimum lock time
Rename an index¶
Last update:
2023-02-03