Home > mailing lists

LIKE pattern - Mailing list pgsql-performance

From	Владимир
Subject	LIKE pattern
Date	May 6, 2016 12:48:09
Msg-id	572C6851.7010600@krevedko.su Whole thread Raw
Responses	Re: LIKE pattern (SoDupuDupu <playtoh87@gmail.com>)
List	pgsql-performance

Tree view

Hello.

It seems my quite complex query runs 10 times faster on "some_column
LIKE '%test_1' " vs "some_column LIKE 'test_1' "
So I just add "%"  to the pattern...

Both query plans use same indexes.

pgsql-performance by date:

From: George Neuner
Date: 28 April 2016, 05:42:13
Subject: testing - please ignore

From: SoDupuDupu
Date: 10 May 2016, 00:41:11
Subject: Re: LIKE pattern

LIKE pattern - Mailing list pgsql-performance

Previous

Next