Hi there, I want to speedup this in postgresql select name

Question

Hi there, I want to speedup this in postgresql select name

from table where name like "string"

I could use pg trm index to speed it up,
any other ways to speedup substring query with posgres ?? full text search doesnt help with this thing

0

31.08.2024

7 ответов

4 просмотра

Fan / Ac Автор вопроса

Thomas
string is hardcoded in the query?

its user input so nope

0

2 месяца назад

Thomas

Fan / Ac
its user input so nope

Then you're f'ed, use a search engine instead

0

2 месяца назад

D

Thomas
Then you're f'ed, use a search engine instead

Search engine or vector database

0

2 месяца назад

Fan / Ac Автор вопроса

Thomas
Then you're f'ed, use a search engine instead

I think pg trm works well, I want to benchmark it, index size of pg trm is huge but the speedup is actually good

0

2 месяца назад

Thomas

D
Search engine or vector database

Search engine

0

2 месяца назад

D

Thomas
Search engine

Elasticsearch

0

2 месяца назад

Thomas · Accepted Answer

Thomas

string is hardcoded in the query?

0

2 месяца назад

Похожие чаты

Hi there, I want to speedup this in postgresql select name

7 ответов

Похожие вопросы