Hi,
On Fri, 2025-06-20 at 09:46 +0800, James Pang wrote:
> same OS RHEL8, install pgv14.11 and pgv18.beta1_3, both installation
> by RPM from pgdg, and use similar postgresql.conf.
> 18.beta1
> postgres=# \timing on
> Timing is on.
> postgres=# select * from tt where b ~~ 'a%';
> a | b
> ---+-
Hi,
On 2025-06-20 09:46:06 +0800, James Pang wrote:
> same OS RHEL8, install pgv14.11 and pgv18.beta1_3, both installation by RPM
> from pgdg, and use similar postgresql.conf.
>
> 14.11
> Time: 55.082 ms
> postgres=# select * from tt where b ~~ 'a%';
> a | b
> ---+---
> (0 rows)
>
> Time: 54.
On Thursday, June 19, 2025, James Pang 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..10
same OS RHEL8, install pgv14.11 and pgv18.beta1_3, both installation by RPM
from pgdg, and use similar postgresql.conf.
14.11
postgres=# create table tt(a int primary key, b text);
CREATE TABLE
postgres=# do
postgres-# $$
postgres$# begin
postgres$#for counter in 1..100 loop
postgres$# ins
