pgjdbc/pgjdbc GitHub issues and pull requests (mirror)  

help / color / mirror / Atom feed

[pgjdbc/pgjdbc] PR #3510: use in row values instead of union all
4+ messages / 2 participants
[nested] [flat]

* [pgjdbc/pgjdbc] PR #3510: use in row values instead of union all
@ 2025-02-04 22:59 "davecramer (@davecramer)" <[email protected]>
  0 siblings, 0 replies; 4+ messages in thread

From: davecramer (@davecramer) @ 2025-02-04 22:59 UTC (permalink / raw)
  To: pgjdbc/pgjdbc <[email protected]>

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

^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: [pgjdbc/pgjdbc] PR #3510: use in row values instead of union all
@ 2025-02-04 22:59 ` "davecramer (@davecramer)" <[email protected]>
  2 siblings, 0 replies; 4+ messages in thread

From: davecramer (@davecramer) @ 2025-02-04 22:59 UTC (permalink / raw)
  To: pgjdbc/pgjdbc <[email protected]>

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

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

^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: [pgjdbc/pgjdbc] PR #3510: use in row values instead of union all
@ 2025-02-12 11:18 ` "vlsi (@vlsi)" <[email protected]>
  2 siblings, 0 replies; 4+ messages in thread

From: vlsi (@vlsi) @ 2025-02-12 11:18 UTC (permalink / raw)
  To: pgjdbc/pgjdbc <[email protected]>

I guess we should rather use array + bind variable.

Could you please provide a before and after execution plan?

^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: [pgjdbc/pgjdbc] PR #3510: use in row values instead of union all
@ 2025-02-12 11:21 ` "vlsi (@vlsi)" <[email protected]>
  2 siblings, 0 replies; 4+ messages in thread

From: vlsi (@vlsi) @ 2025-02-12 11:21 UTC (permalink / raw)
  To: pgjdbc/pgjdbc <[email protected]>

(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()`

^ permalink  raw  reply  [nested|flat] 4+ messages in thread

end of thread, other threads:[~2025-02-12 11:21 UTC | newest]

Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2025-02-04 22:59 [pgjdbc/pgjdbc] PR #3510: use in row values instead of union all "davecramer (@davecramer)" <[email protected]>
2025-02-04 22:59 ` "davecramer (@davecramer)" <[email protected]>
2025-02-12 11:18 ` "vlsi (@vlsi)" <[email protected]>
2025-02-12 11:21 ` "vlsi (@vlsi)" <[email protected]>

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox