All Questions
Tagged with full-text-search postgresql-9.1
6 questions
19
votes
0
answers
6k
views
PostgreSQL trigram GIST vs. GIN indexes
I have a PostgreSQL 9.1 database that contains 10M+ rows and some text fields that need similarity and %word%-like searches, so I decided to use trigram indexes.
Initially, I started to use GIN ...
- 911
18
votes
2
answers
3k
views
Trigram search gets much slower as search string gets longer
In a Postgres 9.1 database, I have a table table1 with ~1.5M rows and a column label (simplified names for the sake of this question).
There is a functional trigram-index on lower(unaccent(label)) (...
- 911
1
vote
0
answers
470
views
PostgreSQL query slow when using tsvector and ORDER BY despite having index
Running on a large database (around 1.5G) The following query takes about 70 seconds to run,
SELECT x
FROM DBText x
WHERE x.status = 2
AND x.publishedTime < 4574590406397
AND x.service = '...
- 11
11
votes
2
answers
2k
views
Slow fulltext search due to wildly inaccurate row estimates
Fulltext queries against this database (storing RT (Request Tracker) tickets) seem to be taking a very long time to execute. The attachments table (containing the fulltext data) is about 15GB.
The ...
- 213
0
votes
1
answer
3k
views
Full text search on multiple tables in PostgreSQL
I have several tables that have related data. I want to have a search input box on the dashboard of the system that will search for anything (client, invoice, delivery note, ...).
Is it possible to ...
- 545
4
votes
1
answer
5k
views
Using Solr/Lucene for searching non-text tables?
I am creating a web application to retrieve subsets of one large (4m rows) table. The 4m rows only change once a year. The table has 200+ columns of types boolean and numeric. It has no text columns.
...
- 857