Re: quick q re migration, index, stats

Поиск
Список
Период
Сортировка
От Scott Ribe
Тема Re: quick q re migration, index, stats
Дата
Msg-id 3C49CA1B-004B-4B39-A8AF-3C376DA1ADEE@elevated-dev.com
обсуждение исходный текст
Ответ на Re: quick q re migration, index, stats  (Laurenz Albe <laurenz.albe@cybertec.at>)
Список pgsql-admin
> On Jan 6, 2021, at 6:56 PM, Laurenz Albe <laurenz.albe@cybertec.at> wrote:
>
> By the way, you only need to rebuild those indexes that contain string data types,
> unless you want to make use of the new index compression feature in v13.

Thanks for pointing that it out; it hadn't occurred to me. But most of our indexes are strings, and we do have some
numerictypes that can have duplicates, so I think I'll be lazy and reindex all instead of trying to pick and choose. 





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

Предыдущее
От: Laurenz Albe
Дата:
Сообщение: Re: quick q re migration, index, stats
Следующее
От: John Scalia
Дата:
Сообщение: Showing materialized views