stgres=# select * from tt where b ~~ 'a%';
a | b
---+---
(0 rows)
Time: 48.176 ms
postgres=# select * from tt where b ~~ 'a%';
a | b
---+---
(0 rows)
Time: 49.919 ms
Thanks,
James
Devrim Gündüz 於 2025年6月21日週六 下午7:13寫道：
> Hi,
>
> On Fri, 2025-06-20 at 09:46 +0800,
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
: PostgreSQL Developers ; James Pang
(chaolpan)
Subject: Re: extended statistics n-distinct on multiple columns not used when
join two tables
út 13. 6. 2023 v 13:26 odesílatel David Rowley
mailto:dgrowle...@gmail.com>> napsal:
(moving to -hackers)
On Tue, 13 Jun 2023 at 21:30, Pavel S
