| From: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
|---|---|
| To: | James Pang <jamespang886(at)gmail(dot)com> |
| Cc: | "pgsql-hackers(at)lists(dot)postgresql(dot)org" <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: pgv18: simple table scan take more time than pgv14 |
| Date: | 2025-06-20 02:13:42 |
| Message-ID: | CAKFQuwY-t15_xnfWo42KrxaSo=EzU0Mmia4+GMrT2_N+nh0TWQ@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Thursday, June 19, 2025, James Pang <jamespang886(at)gmail(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Amit Kapila | 2025-06-20 02:55:34 | Re: Slot's restart_lsn may point to removed WAL segment after hard restart unexpectedly |
| Previous Message | Michael Paquier | 2025-06-20 02:05:37 | Re: problems with toast.* reloptions |