diff options
| author | Dan McGee <dan@archlinux.org> | 2013-04-13 18:56:26 +0200 |
|---|---|---|
| committer | Dan McGee <dan@archlinux.org> | 2013-04-13 18:57:55 +0200 |
| commit | f2a6316be0b025a9ee22f22d34df1c00f60a8bdf (patch) | |
| tree | 6ef9d10db04396700705f8f3b0bf339dcaf79c10 | |
| parent | c588d1c85f86f5ee10a96bec679111c8675b703c (diff) | |
| download | archweb-f2a6316be0b025a9ee22f22d34df1c00f60a8bdf.tar.gz archweb-f2a6316be0b025a9ee22f22d34df1c00f60a8bdf.tar.xz | |
Add additional pg_trgm indexes for quicker searches
This allows our normal keyword-based search to be index-optimized rather
than always doing full table scans. It requires the pg_trgm extension
which is shipped out of the box with any sane install of PostgreSQL.
Signed-off-by: Dan McGee <dan@archlinux.org>
| -rw-r--r-- | packages/sql/search_indexes.postgresql_psycopg2.sql | 3 |
1 files changed, 3 insertions, 0 deletions
diff --git a/packages/sql/search_indexes.postgresql_psycopg2.sql b/packages/sql/search_indexes.postgresql_psycopg2.sql new file mode 100644 index 0000000..a7eaf99 --- /dev/null +++ b/packages/sql/search_indexes.postgresql_psycopg2.sql @@ -0,0 +1,3 @@ +CREATE EXTENSION IF NOT EXISTS pg_trgm; +CREATE INDEX packages_pkgname_trgm_gist ON packages USING gist (UPPER(pkgname) gist_trgm_ops); +CREATE INDEX packages_pkgdesc_trgm_gist ON packages USING gist (UPPER(pkgdesc) gist_trgm_ops); |