Re: Pathological performance when inserting many NULLs into a uniqueindex

Поиск
Список
Период
Сортировка
От Michael Paquier
Тема Re: Pathological performance when inserting many NULLs into a uniqueindex
Дата
Msg-id 20190419004613.GE2660@paquier.xyz
обсуждение исходный текст
Ответ на Pathological performance when inserting many NULLs into a unique index  (Peter Geoghegan <pg@bowt.ie>)
Ответы Re: Pathological performance when inserting many NULLs into a unique index  (Peter Geoghegan <pg@bowt.ie>)
Список pgsql-hackers
On Wed, Apr 17, 2019 at 07:37:17PM -0700, Peter Geoghegan wrote:
> I'll create an open item for this, and begin work on a patch tomorrow.

Adding an open item is adapted, nice you found this issue.  Testing on
my laptop with v11, the non-NULL case takes 5s and the NULL case 6s.
On HEAD, the non-NULL case takes 6s, and the NULL case takes...  I
just gave up and cancelled it :)
--
Michael

Вложения

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

Предыдущее
От: Michael Paquier
Дата:
Сообщение: Re: finding changed blocks using WAL scanning
Следующее
От: Tom Lane
Дата:
Сообщение: Re: "make installcheck" fails in src/test/recovery