Changeset View
Changeset View
Standalone View
Standalone View
sql/upgrades/135.sql
- This file was added.
-- SWH DB schema upgrade | |||||
-- from_version: 134 | |||||
-- to_version: 135 | |||||
-- description: Add an index on origin.url, drop the index on (origin.type, origin.url) | |||||
insert into dbversion(version, release, description) | |||||
values(135, now(), 'Work In Progress'); | |||||
ardumont: 135? | |||||
create extension if not exists pg_trgm; | |||||
Not Done Inline ActionsI think that needs to run as postgres user. ardumont: I think that needs to run as postgres user.
So not sure if that needs to be declared here… | |||||
Done Inline Actionscreate extension statements are in swh/storage/sql/ same as everything else, so it's consistent to put that in the migration script. vlorentz: `create extension` statements are in `swh/storage/sql/` same as everything else, so it's… | |||||
Not Done Inline ActionsYes. ardumont: Yes.
My doubt is not about consistency, it's about running when applied during migration.
But… | |||||
drop index origin_type_url_idx; | |||||
create index concurrently on origin using gin (url gin_trgm_ops); | |||||
create index concurrently on origin using hash (url); |
135?