Home > mailing lists

request for database identifier in the startup packet - Mailing list pgsql-hackers

From	Dave Cramer
Subject	request for database identifier in the startup packet
Date	May 9 15:06:11
Msg-id	CADK3HHL=De9nkuzKbxQq0cumCUPHiwkVAYDfyBACsCWq3xwwrA@mail.gmail.com Whole thread Raw
Responses	Re: request for database identifier in the startup packet Re: request for database identifier in the startup packet
List	pgsql-hackers

Greetings,

The JDBC driver is currently keeping a per connection cache of types in the driver. We are seeing cases where the number of columns is quite high. In one case Prevent fetchFieldMetaData() from being run when unnecessary. · Issue #3241 · pgjdbc/pgjdbc (github.com) 2.6 Million columns.

If we knew that we were connecting to the same database we could use a single cache across connections.

I think we would require a server/database identifier in the startup message.

Dave Cramer

From: jian he
Date: 09 May, 14:49:55
Subject: Re: First draft of PG 17 release notes

From: Tomas Vondra
Date: 09 May, 15:19:23
Subject: Re: Parallel CREATE INDEX for GIN indexes