Re: PROPOSAL: Support global and local disabling of indexes

Поиск
Список
Период
Сортировка
От Adam Brusselback
Тема Re: PROPOSAL: Support global and local disabling of indexes
Дата
Msg-id CAMjNa7cNNq_so_OE51Y-r07VSOmBD3cRZvteFvBRH0DGn8kMMA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: PROPOSAL: Support global and local disabling of indexes  (Justin Pryzby <pryzby@telsasoft.com>)
Список pgsql-hackers
Дерево обсуждения
Just wanted to mention that this would be a useful feature for me. Had previously been bitten by this: https://www.postgresql.org/message-id/flat/CAMjNa7c4pKLZe%2BZ0V49isKycnXQ6Y%3D3BO-4Gsj3QAwsd2r7Wrw%40mail.gmail.com

Ended up "solving" by putting a where clause on all my exclusion constraints I didn't want used for most queries (WHERE 1=1). That allowed me "disable" that index for all queries unless they explicitly have a 1=1 constant in the where clause.


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

Предыдущее
От: Nitin Jadhav
Дата:
Сообщение: Re: Report checkpoint progress with pg_stat_progress_checkpoint (was: Report checkpoint progress in server logs)
Следующее
От: Aleksander Alekseev
Дата:
Сообщение: Re: XID formatting and SLRU refactorings (was: Add 64-bit XIDs into PostgreSQL 15)