· 7 years ago · Oct 31, 2018, 11:50 PM
1CREATE TABLE IF NOT EXISTS "public"."bench2" (
2 "tags_text_1" text[],
3 "tags_text_2" text[]
4)
5
6CREATE INDEX "idx_tags_text_1" ON "public"."bench2" USING gin ("tags_text_1")
7
8SELECT count(*) from bench2 WHERE tags_text_1 && ARRAY['tag1']
9SELECT count(*) from bench2 WHERE tags_text_2 && ARRAY['tag1']
10
11SELECT count(*) from bench2 WHERE tags_text_1 @> ARRAY['tag1']
12SELECT count(*) from bench2 WHERE tags_text_2 @> ARRAY['tag1']
13
14SELECT count(*) from bench2 WHERE tags_text_1 <@ ARRAY['tag1']
15SELECT count(*) from bench2 WHERE tags_text_2 <@ ARRAY['tag1']