Postgres Pro
Downloads
Home   >   mailing lists

Re: Pathological performance when inserting many NULLs into a uniqueindex - Mailing list pgsql-hackers

From Michael Paquier
Subject Re: Pathological performance when inserting many NULLs into a uniqueindex
Date
Msg-id 20190419004613.GE2660@paquier.xyz
Whole thread Raw
In response to Pathological performance when inserting many NULLs into a unique index  (Peter Geoghegan <pg@bowt.ie>)
Responses Re: Pathological performance when inserting many NULLs into a unique index
List pgsql-hackers
Tree view 
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
Attachment

pgsql-hackers by date:

Previous
From: Michael Paquier
Date:
Subject: Re: finding changed blocks using WAL scanning
Next
From: Tom Lane
Date:
Subject: Re: "make installcheck" fails in src/test/recovery