Re: Possible regression in PG18 beta1

Поиск
Список
Период
Сортировка
От Sadeq Dousti
Тема Re: Possible regression in PG18 beta1
Дата
Msg-id CADE6LvjBOrFObDOGBayzcLfWRScN6hHQopPjj5R_hSeJXOjauw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Possible regression in PG18 beta1  (Sami Imseih <samimseih@gmail.com>)
Список pgsql-hackers
thanks. I don't see regression for a normal table, at least for this test.

No, there isn't. I just added them as per your request ;) 


In terms of your original test, I tried it out on my Ubuntu machine
and with your test as-is, I see 2.8 seconds on 17.5 and 3.3 seconds
on HEAD if the plan performs a seq scan without parallelism.

Which is unexpected, no? 


However, the test as you have it is indexing all columns
on the table. If I just index on the filtered column

Yes, I agree. Changing the indexing setup will diminish the difference. However, given the sub-optimal index, PG18 seems to be slower.

Also, there's a meaningful difference in the plans for TEMP table vs. UNLOGGED, which is interesting.

Best regards, 
Sadeq Dousti 

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