Subject: [pgjdbc/pgjdbc] PR #3510: use in row values instead of union all

From: "davecramer (@davecramer)" <[email-masked]>
Date: Tue, 04 Feb 2025 22:59:00 +0000

There have been issues regarding performance, hopefully this helps.
The select is certainly simpler

---

From: "davecramer (@davecramer)" <[email-masked]>
Date: Tue, 04 Feb 2025 22:59:30 +0000

(on pgjdbc/src/main/java/org/postgresql/jdbc/PgResultSetMetaData.java:226)

@vlsi do you know what `hasSourceInfo` does here ?

---

From: "vlsi (@vlsi)" <[email-masked]>
Date: Wed, 12 Feb 2025 11:18:14 +0000

I guess we should rather use array + bind variable.

Could you please provide a before and after execution plan?

---

From: "vlsi (@vlsi)" <[email-masked]>
Date: Wed, 12 Feb 2025 11:21:27 +0000

(on pgjdbc/src/main/java/org/postgresql/jdbc/PgResultSetMetaData.java:252)

Why removing this?

Previously, `fieldInfoFetched` was set to `true` in case metadata for all the fields was known.
I guess it was there to prevent duplicate queries from `fetchFieldMetaData()`