Re: pgv18: simple table scan take more time than pgv14

On Thursday, June 19, 2025, James Pang <jamespang886@gmail.com> wrote:

> same OS RHEL8, install pgv14.11 and pgv18.beta1_3, both installation by
> RPM from pgdg, and use similar postgresql.conf.
>

You will need to show encoding and locale information for the databases
under test.


>
> postgres$#    for counter in 1..1000000 loop
> postgres$# insert into tt values(counter,'jamestest');
>
>
Using generate_series is a lot easier and faster.


> Also, filtering using the operator “~~” doesn’t constitute a “simple”
table scan.

David J.