>> > * 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)
