diff options
| author | Omar Roth <omarroth@hotmail.com> | 2018-07-27 17:38:47 -0500 |
|---|---|---|
| committer | Omar Roth <omarroth@hotmail.com> | 2018-07-27 17:38:47 -0500 |
| commit | b13b91e2bf6e9a9a8af442e5ee8bb4eaf3758f21 (patch) | |
| tree | e2193440c91dc2e408634f8e9910d9e84a975484 /config/sql | |
| parent | ff563d075aa9c5f8a262986036a7223f08de449d (diff) | |
| download | invidious-b13b91e2bf6e9a9a8af442e5ee8bb4eaf3758f21.tar.gz invidious-b13b91e2bf6e9a9a8af442e5ee8bb4eaf3758f21.tar.bz2 invidious-b13b91e2bf6e9a9a8af442e5ee8bb4eaf3758f21.zip | |
Add ucid index for channel_videos
Diffstat (limited to 'config/sql')
| -rw-r--r-- | config/sql/channel_videos.sql | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/config/sql/channel_videos.sql b/config/sql/channel_videos.sql index 98d4d7de..4e48c70b 100644 --- a/config/sql/channel_videos.sql +++ b/config/sql/channel_videos.sql @@ -26,4 +26,13 @@ GRANT ALL ON TABLE public.channel_videos TO kemal; CREATE INDEX channel_videos_published_idx ON public.channel_videos USING btree (published) + TABLESPACE pg_default; + +-- Index: channel_videos_ucid_idx + +-- DROP INDEX public.channel_videos_ucid_idx; + +CREATE INDEX channel_videos_ucid_idx + ON public.channel_videos USING btree + (ucid COLLATE pg_catalog."default") TABLESPACE pg_default;
\ No newline at end of file |