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.