queries.txt

postgres=# EXPLAIN SELECT name FROM categories WHERE similarity(name, 'cr') > 0.3;
                                 QUERY PLAN
----------------------------------------------------------------------------
 Seq Scan on categories  (cost=0.00..208.55 rows=2323 width=9)
   Filter: (similarity((name)::text, 'cr'::text) > '0.3'::double precision)
(2 rows)

schema.sql

CREATE TABLE venue(
  id VARCHAR(24) UNIQUE PRIMARY KEY
);

CREATE TABLE categories(
  venue_id              VARCHAR(24) REFERENCES venue(id) ON DELETE CASCADE,
  name                  VARCHAR(30)
);

CREATE INDEX category_name_idx ON tags USING GIST(name gist_trgm_ops);