Re: Multiple FPI_FOR_HINT for the same block during killing btreeindex items

Поиск
Список
Период
Сортировка
От Peter Geoghegan
Тема Re: Multiple FPI_FOR_HINT for the same block during killing btreeindex items
Дата
Msg-id CAH2-Wzm-Pf2xKR2mfk55s88_8RGXix2VJH4R0Wmk7=YwVuH19Q@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Multiple FPI_FOR_HINT for the same block during killing btreeindex items  (Peter Geoghegan <pg@bowt.ie>)
Ответы Re: Multiple FPI_FOR_HINT for the same block during killing btreeindex items
Список pgsql-hackers
On Thu, Apr 9, 2020 at 5:25 PM Peter Geoghegan <pg@bowt.ie> wrote:
> Was this a low cardinality index in the way I describe? If it was,
> then we can hope (and maybe even verify) that the Postgres 12 work
> noticeably ameliorates the problem.

What I really meant was an index where hundreds or even thousands of
rows for each distinct timestamp value are expected. Not an index
where almost every row has a distinct timestamp value. Both timestamp
index patterns are common, obviously.

-- 
Peter Geoghegan



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

Предыдущее
От: Peter Geoghegan
Дата:
Сообщение: Re: Multiple FPI_FOR_HINT for the same block during killing btreeindex items
Следующее
От: Andres Freund
Дата:
Сообщение: Re: Catalog invalidations vs catalog scans vs ScanPgRelation()