diff options
| author | Omar Roth <omarroth@hotmail.com> | 2018-09-21 08:52:27 -0500 |
|---|---|---|
| committer | Omar Roth <omarroth@hotmail.com> | 2018-09-21 08:52:27 -0500 |
| commit | 51d00b16c3a0852d41dd1cff02ba95f974042ab7 (patch) | |
| tree | 039cccd9e9660be756d73e0b41d4f3e3ba54782d /config/sql | |
| parent | bead12d6d08e4db15d44185f99742206e673e59a (diff) | |
| download | invidious-51d00b16c3a0852d41dd1cff02ba95f974042ab7.tar.gz invidious-51d00b16c3a0852d41dd1cff02ba95f974042ab7.tar.bz2 invidious-51d00b16c3a0852d41dd1cff02ba95f974042ab7.zip | |
Use hash instead of btree for channel_videos_ucid_idx
Diffstat (limited to 'config/sql')
| -rw-r--r-- | config/sql/channel_videos.sql | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/config/sql/channel_videos.sql b/config/sql/channel_videos.sql index 4e48c70b..9e84092c 100644 --- a/config/sql/channel_videos.sql +++ b/config/sql/channel_videos.sql @@ -33,6 +33,6 @@ CREATE INDEX channel_videos_published_idx -- DROP INDEX public.channel_videos_ucid_idx; CREATE INDEX channel_videos_ucid_idx - ON public.channel_videos USING btree + ON public.channel_videos USING hash (ucid COLLATE pg_catalog."default") TABLESPACE pg_default;
\ No newline at end of file |