Re: Possible regression in PG18 beta1 - Mailing list pgsql-hackers

From Sami Imseih
Subject Re: Possible regression in PG18 beta1
Date
Msg-id CAA5RZ0trV3Y93U3usD6EmpfViHR=+7exFEhutJO3ExWtu9L0ew@mail.gmail.com
Whole thread Raw
In response to Re: Possible regression in PG18 beta1  (Sadeq Dousti <msdousti@gmail.com>)
List pgsql-hackers
>> > * Also, I noticed "explain analyze" reports actual rows as a decimal
>> > number (1.00) as opposed to an integer (1); not sure if that's intentional.

Yes, this is intentional as of 95dbd827f2edc

>> > * Changing the table from TEMP to UNLOGGED makes both versions use
>> > "Parallel Seq Scan", with PG18 being ~25% faster. (190ms vs. 150ms).

I'll be curious about tests with a normal table as well with a
sufficiently large
shared_buffers.

--
Sami Imseih
Amazon Web Services (AWS)



pgsql-hackers by date:

Previous
From: Maciek Sakrejda
Date:
Subject: Re: Possible regression in PG18 beta1
Next
From: Andreas Karlsson
Date:
Subject: Re: pg_upgrade ability to create extension from scripts