host - Windows Server 2022
postgresql - 14.8
pgAdmin 4 - 7.1
openssl - 3.1.0
So I have generated a key and csr file to be sent to a CA cert issuer InCommon.
I generated via openssl with the following command.
openssl.exe req -newkey rsa:2048 -nodes -keyout postgresql.key -out
postgresql.csr
Hello PostgreSQL community,
I am trying to improve performance of using similarity based queries on a
large datasets and I would like to confirm my understanding of how GIN
indexes work and how pg_trgm uses them.
If I understand it correctly, using GIN index is always a two step process:
first,
On 2023-May-23, Ron wrote:
> We'd never hardlink. Eliminates the ability to return to the old system if
> something goes wrong.
If you'd never hardlink, then you should run your test without the -k
option. Otherwise, the timings are meaningless.
--
Álvaro Herrera PostgreSQL Developer
jian he writes:
> should I expect the typdelim be a white space? Since '1 2'::int2vector
> works, '1,2'::int2vector does not work.
typdelim applies to the type's associated array type, that is
int2vector[].
regression=# select '{1 2,3 4 5}'::int2vector[];
int2vector
-
hi.
select
pt.typtype
, pt.typcategory
, pt.typdelim
, pt.typelem
, pt1.typname as elem_type
,pt.typsubscript
,pt.typname
frompg_type pt join pg_type pt1 on pt.typelem = pt1.oid
where pt.typname = 'int2vector';
returns
typtype |
