Differential D2346 Diff 8088 swh/storage/sql/60-swh-indexes.sql

Changeset View

Standalone View

	Show All 10 Lines


	-- origin			-- origin
	create unique index concurrently origin_pkey on origin(id);			create unique index concurrently origin_pkey on origin(id);
	alter table origin add primary key using index origin_pkey;			alter table origin add primary key using index origin_pkey;

	create index concurrently on origin using gin (url gin_trgm_ops);			create index concurrently on origin using gin (url gin_trgm_ops);
	create index concurrently on origin using hash (url);			create index concurrently on origin using hash (url);
				create index concurrently on origin using btree(digest(url, 'sha1'));


	-- skipped_content			-- skipped_content

	alter table skipped_content add constraint skipped_content_sha1_sha1_git_sha256_key unique (sha1, sha1_git, sha256);			alter table skipped_content add constraint skipped_content_sha1_sha1_git_sha256_key unique (sha1, sha1_git, sha256);

	create index concurrently on skipped_content(sha1);			create index concurrently on skipped_content(sha1);
	create index concurrently on skipped_content(sha1_git);			create index concurrently on skipped_content(sha1_git);
	▲ Show 20 Lines • Show All 152 Lines • Show Last 20 Lines