Request a Demo
Home   >   mailing lists

Re: pgv18: simple table scan take more time than pgv14 - Mailing list pgsql-hackers

From David G. Johnston
Subject Re: pgv18: simple table scan take more time than pgv14
Date
Msg-id CAKFQuwY-t15_xnfWo42KrxaSo=EzU0Mmia4+GMrT2_N+nh0TWQ@mail.gmail.com
Whole thread Raw
In response to pgv18: simple table scan take more time than pgv14  (James Pang <jamespang886@gmail.com>)
List pgsql-hackers
Tree view
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.


pgsql-hackers by date:

Previous
From: James Pang
Date:
Subject: pgv18: simple table scan take more time than pgv14
Next
From: Amit Kapila
Date:
Subject: Re: Slot's restart_lsn may point to removed WAL segment after hard restart unexpectedly