Differential D2148 Diff 7308 swh/storage/sql/60-swh-indexes.sql

Changeset View

Standalone View

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

	Show All 25 Lines
	create index concurrently on skipped_content(sha1_git);			create index concurrently on skipped_content(sha1_git);
	create index concurrently on skipped_content(sha256);			create index concurrently on skipped_content(sha256);
	create index concurrently on skipped_content(blake2s256);			create index concurrently on skipped_content(blake2s256);
	create unique index concurrently on skipped_content(object_id);			create unique index concurrently on skipped_content(object_id);

	alter table skipped_content add constraint skipped_content_origin_fkey foreign key (origin) references origin(id) not valid;			alter table skipped_content add constraint skipped_content_origin_fkey foreign key (origin) references origin(id) not valid;
	alter table skipped_content validate constraint skipped_content_origin_fkey;			alter table skipped_content validate constraint skipped_content_origin_fkey;

	-- fetch_history

	create unique index concurrently fetch_history_pkey on fetch_history(id);
	alter table fetch_history add primary key using index fetch_history_pkey;

	alter table fetch_history add constraint fetch_history_origin_fkey foreign key (origin) references origin(id) not valid;
	alter table fetch_history validate constraint fetch_history_origin_fkey;

	-- directory			-- directory

	create unique index concurrently directory_pkey on directory(id);			create unique index concurrently directory_pkey on directory(id);
	alter table directory add primary key using index directory_pkey;			alter table directory add primary key using index directory_pkey;

	create index concurrently on directory using gin (dir_entries);			create index concurrently on directory using gin (dir_entries);
	create index concurrently on directory using gin (file_entries);			create index concurrently on directory using gin (file_entries);
	create index concurrently on directory using gin (rev_entries);			create index concurrently on directory using gin (rev_entries);
	▲ Show 20 Lines • Show All 137 Lines • Show Last 20 Lines