Re: Temporarily very slow planning time after a big delete

Поиск
Список
Период
Сортировка
От Peter Geoghegan
Тема Re: Temporarily very slow planning time after a big delete
Дата
Msg-id CAH2-WzmC1GXMM6E2Erg9LF3KMY4EHBQC49ERVkkbsoq3141nUw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Temporarily very slow planning time after a big delete  (Walter Smith <walter@carezone.com>)
Ответы Re: Temporarily very slow planning time after a big delete  (Walter Smith <walter@carezone.com>)
Список pgsql-performance
On Tue, May 21, 2019 at 11:16 AM Walter Smith <walter@carezone.com> wrote:
> It occurs to me that is a somewhat unusual index -- it tracks unprocessed notifications so it gets an insert and
deletefor every row, and is normally almost empty.
 

Is it a very low cardinality index? In other words, is the total
number of distinct keys rather low? Not just at any given time, but
over time?

-- 
Peter Geoghegan



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

Предыдущее
От: Walter Smith
Дата:
Сообщение: Re: Temporarily very slow planning time after a big delete
Следующее
От: Walter Smith
Дата:
Сообщение: Re: Temporarily very slow planning time after a big delete