Re: pg12 - partition by column that might have null values

Поиск
Список
Период
Сортировка
От Michael Lewis
Тема Re: pg12 - partition by column that might have null values
Дата
Msg-id CAHOFxGrRE0DWbgGMteo4rM7RWoZqZ_JMxOk+a=aGALEKVdxY5w@mail.gmail.com
обсуждение исходный текст
Ответ на Re: pg12 - partition by column that might have null values  (Mariel Cherkassky <mariel.cherkassky@gmail.com>)
Список pgsql-performance
Дерево обсуждения
Just create a partial index on id column where end_date = infinity (or null if you really prefer that pattern) and the system can quickly find the rows that are still most current revision. How many rows do you have in this table? Or foresee ever having? What took you down the road of partitioning the table? Theory only, or solving a real life optimization problem?

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

Предыдущее
От: Mariel Cherkassky
Дата:
Сообщение: Re: pg12 - partition by column that might have null values
Следующее
От: Ogden Brash
Дата:
Сообщение: Some observations on very slow pg_restore operations