Differential D1556 Diff 5117 swh/storage/sql/60-swh-indexes.sql

Changeset View

Standalone View

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

	-- content			-- content

	create unique index concurrently content_pkey on content(sha1);			create unique index concurrently content_pkey on content(sha1);
	create unique index concurrently on content(sha1_git);			create unique index concurrently on content(sha1_git);
	create index concurrently on content(sha256);			create index concurrently on content(sha256);
	create index concurrently on content(blake2s256);			create index concurrently on content(blake2s256);
	create index concurrently on content(ctime); -- TODO use a BRIN index here (postgres >= 9.5)			create index concurrently on content(ctime); -- TODO use a BRIN index here (postgres >= 9.5)
	create unique index concurrently on content(object_id);			create unique index concurrently on content(object_id);

	alter table content add primary key using index content_pkey;			alter table content add primary key using index content_pkey;


	-- 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(type, url);			create index concurrently on origin using gin (url gin_trgm_ops);
				create index concurrently on origin using hash (url);


	-- 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 156 Lines • Show Last 20 Lines