Changeset View
Changeset View
Standalone View
Standalone View
swh/storage/sql/60-indexes.sql
Show First 20 Lines • Show All 275 Lines • ▼ Show 20 Lines | |||||
-- object_counts | -- object_counts | ||||
create unique index concurrently object_counts_pkey on object_counts(object_type); | create unique index concurrently object_counts_pkey on object_counts(object_type); | ||||
alter table object_counts add primary key using index object_counts_pkey; | alter table object_counts add primary key using index object_counts_pkey; | ||||
-- object_counts_bucketed | -- object_counts_bucketed | ||||
create unique index concurrently object_counts_bucketed_pkey on object_counts_bucketed(line); | create unique index concurrently object_counts_bucketed_pkey on object_counts_bucketed(line); | ||||
alter table object_counts_bucketed add primary key using index object_counts_bucketed_pkey; | alter table object_counts_bucketed add primary key using index object_counts_bucketed_pkey; | ||||
-- extid | |||||
create unique index concurrently on extid(extid_type, extid); | |||||
create unique index concurrently on extid(target_type, target); |