On Thursday, June 19, 2025, James Pang <jamespang...@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.
