Differential D3342 Diff 11853 swh/storage/sql/60-swh-indexes.sql

Changeset View

Standalone View

swh/storage/sql/60-swh-indexes.sql

	Show First 20 Lines • Show All 120 Lines • ▼ Show 20 Lines
	alter table snapshot_branches add constraint snapshot_branches_branch_id_fkey foreign key (branch_id) references snapshot_branch(object_id) not valid;			alter table snapshot_branches add constraint snapshot_branches_branch_id_fkey foreign key (branch_id) references snapshot_branch(object_id) not valid;
	alter table snapshot_branches validate constraint snapshot_branches_branch_id_fkey;			alter table snapshot_branches validate constraint snapshot_branches_branch_id_fkey;

	-- origin_visit			-- origin_visit
	create unique index concurrently origin_visit_pkey on origin_visit(origin, visit);			create unique index concurrently origin_visit_pkey on origin_visit(origin, visit);
	alter table origin_visit add primary key using index origin_visit_pkey;			alter table origin_visit add primary key using index origin_visit_pkey;

	create index concurrently on origin_visit(date);			create index concurrently on origin_visit(date);
	create index concurrently on origin_visit(type, status, date);			create index concurrently on origin_visit(type, date);
				vlorentzUnsubmitted Not Done Inline Actions could you give it a name? (to make sure we don't get different names on prod vs dev) vlorentz: could you give it a name? (to make sure we don't get different names on prod vs dev)
				ardumontAuthorUnsubmitted Done Inline Actions that's a good point ;) will do. ardumont: that's a good point ;) will do.

	alter table origin_visit add constraint origin_visit_origin_fkey foreign key (origin) references origin(id) not valid;			alter table origin_visit add constraint origin_visit_origin_fkey foreign key (origin) references origin(id) not valid;
	alter table origin_visit validate constraint origin_visit_origin_fkey;			alter table origin_visit validate constraint origin_visit_origin_fkey;

	-- origin_visit_status			-- origin_visit_status

	create unique index concurrently origin_visit_status_pkey on origin_visit_status(origin, visit, date);			create unique index concurrently origin_visit_status_pkey on origin_visit_status(origin, visit, date);
	alter table origin_visit_status add primary key using index origin_visit_status_pkey;			alter table origin_visit_status add primary key using index origin_visit_status_pkey;
	▲ Show 20 Lines • Show All 55 Lines • Show Last 20 Lines