Re: BUG #18205: Performance regression with NOT NULL checks.

Поиск
Список
Период
Сортировка
От Andres Freund
Тема Re: BUG #18205: Performance regression with NOT NULL checks.
Дата
Msg-id 20231119223911.rt73qzjykzxi6jcf@awork3.anarazel.de
обсуждение исходный текст
Ответ на Re: BUG #18205: Performance regression with NOT NULL checks.  (Andres Freund <andres@anarazel.de>)
Ответы AW: BUG #18205: Performance regression with NOT NULL checks.  (Daniel Migowski <dmigowski@ikoffice.de>)
Список 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 по дате отправления:

Предыдущее
От: Andres Freund
Дата:
Сообщение: Re: BUG #18205: Performance regression with NOT NULL checks.
Следующее
От: Andres Freund
Дата:
Сообщение: Re: BUG #18205: Performance regression with NOT NULL checks.