Any hints are there in postgres to fetch query fast

Question

PostgreSQL (English)

Esh

Any hints are there in postgres to fetch query fast

?

#programming #russian

0

27.03.2024

5 ответов

8 просмотров

Esh Автор вопроса

Stefanie Janine Stölting
Nope. Hints are an Oracle invention to trick their...

Hmm, after put index then also not working, still take more time

0

1 месяц назад

Stefanie Janine Stölting

Esh
Hmm, after put index then also not working, still ...

It depends on what you are doing just adding more indexes is wrong in most cases. If it's a big table, an index will be big. In that case a BRIN index might help as it is much smaller because it indexes ranges. Have you checked your execution plan? Do you understand what it is doing? There's no one solution that fixes anything.

0

1 месяц назад

Stefanie Janine Stölting

Esh
Hmm, after put index then also not working, still ...

Maybe you can share your EXPLAIN ANALYZE results with us on https://explain.depesz.com/

0

1 месяц назад

Esh Автор вопроса

Stefanie Janine Stölting
Maybe you can share your EXPLAIN ANALYZE results w...

Wil see if I post

0

1 месяц назад

Stefanie Janine Stölting · Accepted Answer

Stefanie Janine Stölting

Nope. Hints are an Oracle invention to trick their stupid optimiser. Analyze (EXPLAIN ANALYZE) your queries, find missing indexes, remove unused indexes. Use the right index type etc.

0

1 месяц назад

169 похожих чатов

Any hints are there in postgres to fetch query fast

5 ответов

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