Re: Forcing index usage

Поиск
Список
Период
Сортировка
От Michael Lewis
Тема Re: Forcing index usage
Дата
Msg-id CAHOFxGrN659igBLGUh+DMvsrRiqBkO+Lr9sv1HSA81Y+YSmZCQ@mail.gmail.com
обсуждение исходный текст
Ответ на Forcing index usage  (Jonathan Marks <jonathanaverymarks@gmail.com>)
Ответы Re: Forcing index usage
Список pgsql-general
Is there a way to tell Postgres “please don’t use index X when queries that could use index Y instead occur?”

No. But you could re-write the query to make the date index useless. The simplest way that comes to mind is putting the query that does your full-text search in a CTE (WITH keyword, it is an optimization boundary) and then ordering and applying your limit to the materialized set that comes out of that. eg.

WITH cte_full_text_results AS(
SELECT date, result FROM big_a_table WHERE text = 'whatever'
)
SELECT * FROM cte_full_text_results ORDER BY date DESC limit 10;

В списке pgsql-general по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: PostgreSQL Windows 2019 support ?
Следующее
От: Perumal Raj
Дата:
Сообщение: Re: Recommendation to run vacuum FULL in parallel