On Sun, Nov 13, 2016 at 3:54 AM, Aaron Lewis
wrote:
> I have a simple table with Trigram index,
>
> create table mytable(hash char(40), title text);
> create index title_trgm_idx on mytable using gin(title gin_trgm_ops);
>
> When I run a query with 10m rows, it uses the Trigram index, but takes
>
On Sun, Nov 13, 2016 at 5:25 PM, Aaron Lewis
wrote:
> Thanks Oleg.
>
> I've increased work_mem to 128MB, now the query falls down to 1.7s,
> faster but still not good enough.
>
> Is there any other thing I can do about it?
>
your query 'x264' is short in terms of the number of trigrams, so trigr
Thanks Oleg.
I've increased work_mem to 128MB, now the query falls down to 1.7s,
faster but still not good enough.
Is there any other thing I can do about it?
test=# explain analyze select * from mytable where title ilike 'x264';
QUER
On Sun, Nov 13, 2016 at 2:54 PM, Aaron Lewis
wrote:
> I have a simple table with Trigram index,
>
> create table mytable(hash char(40), title text);
> create index title_trgm_idx on mytable using gin(title gin_trgm_ops);
>
> When I run a query with 10m rows, it uses the Trigram index, but takes
>
I have a simple table with Trigram index,
create table mytable(hash char(40), title text);
create index title_trgm_idx on mytable using gin(title gin_trgm_ops);
When I run a query with 10m rows, it uses the Trigram index, but takes
3s to execute, very slow.
(I have 80m rows, but only inserted 10m
