Hello Arjen.
Thank you for replying.
I'll try OR query on my environment.
Thanks.
2016年1月4日(月) 23:03 Arjen Nienhuis :
>
> On Jan 4, 2016 09:45, "Hiroyuki Sato" wrote:
> >
> > Hello Arjen
> >
> > Thank you for replying.
> >
> > 201
Hello Arjen
Thank you for replying.
2016年1月4日(月) 16:49 Arjen Nienhuis :
>
> On Dec 28, 2015 00:55, "Hiroyuki Sato" wrote:
> >
> > Hello Andreas and Tom
> >
> > Thank you for replying.
> >
> > Sorry, I re-created my questions. I was mis-paste
Hello David
Thank your for your comment.
2015年12月30日(水) 10:15 David Rowley :
> On 30 December 2015 at 13:56, Hiroyuki Sato wrote:
>
>> 2015年12月30日(水) 6:04 David Rowley :
>>
>>> On 30 December 2015 at 04:21, Hiroyuki Sato wrote:
>>>
Hello David
Thank you for replying.
2015年12月30日(水) 6:04 David Rowley :
> On 30 December 2015 at 04:21, Hiroyuki Sato wrote:
>
>> 2015年12月29日(火) 4:35 Jeff Janes :
>>
>>>
>>>
>> But, the planner refuses to use this index for your query anyway,
>>
Hello Jeff
Thank you for replying.
2015年12月29日(火) 4:35 Jeff Janes :
> On Sun, Dec 27, 2015 at 3:53 PM, Hiroyuki Sato
> wrote:
> > Hello Andreas and Tom
> >
> > Thank you for replying.
> >
> > Sorry, I re-created my questions. I was mis-paste
Hello Tom.
Thank you for replying.
This is Gin Index result.
It is slow too.
Best regards.
--
Hiroyuki Sato
1, create.sql
drop table if exists url_lists4;
create table url_lists4 (
id int not null primary key,
url text not null
);
--create index ix_url_url_lists4
0 width=57) (actual time=41.426..42.115 rows=1
loops=5000)
Index Cond: (url ~~ k.url)
Rows Removed by Index Recheck: 0
Planning time: 0.138 ms
Execution time: 210642.896 ms
(8 rows)
2015年12月28日(月) 9:36 Tom Lane :
> Hiroyuki Sato writes:
>
(2) What kind of Index should I create on url_lists table?
3, Environment
OS: CentOS7
PostgreSQL 9.4
4, sample source
https://github.com/hiroyuki-sato/postgres_like_test
5, Create table
drop table if exists url_lists4;
create table url_lists4 (
id int not null primary key,
Hello.
I would like to create the query like the following.
It work well, but extreme slow.
Is it possible to improve this query like the command ``grep -f keyword
data``?
What kind of Index should I create on url_lists table?
Detail
https://gist.github.com/hiroyuki-sato/574b8ea5d9396e455d60
