Re: BUG #18205: Performance regression with NOT NULL checks. - Mailing list pgsql-bugs

From Andres Freund
Subject Re: BUG #18205: Performance regression with NOT NULL checks.
Date
Msg-id 20231119223911.rt73qzjykzxi6jcf@awork3.anarazel.de
Whole thread Raw
In response to Re: BUG #18205: Performance regression with NOT NULL checks.  (Andres Freund <andres@anarazel.de>)
Responses AW: BUG #18205: Performance regression with NOT NULL checks.  (Daniel Migowski <dmigowski@ikoffice.de>)
List pgsql-bugs
Hi,

On 2023-11-19 14:17:44 -0800, Andres Freund wrote:
> On 2023-11-19 21:15:37 +0000, Daniel Migowski wrote:
> > And yes, in my real world use case which I tried to understand I have a wide
> > table with 81 columns, and I am using column 1,43,18,75 and filter by
> > attribute 82,42, and 24.
> 
> Are most of the columns NULL or not?

Another question: In the real query, how selective is the WHERE clause? In
your test query all rows are returned and you have no columns in the select
list, but it doesn't sound like that's quite your real workload...

Greetings,

Andres Freund



pgsql-bugs by date:

Previous
From: Andres Freund
Date:
Subject: Re: BUG #18205: Performance regression with NOT NULL checks.
Next
From: Andres Freund
Date:
Subject: Re: BUG #18205: Performance regression with NOT NULL checks.