Message-ID: <gh-pgjdbc-pgjdbc-3511-c2642726101@github.com>
From: "davecramer (@davecramer)" <noreply+davecramer@github.com>
To: "pgjdbc/pgjdbc" <noreply+pgjdbc-pgjdbc@github.com>
Date: Fri, 07 Feb 2025 11:55:55 +0000
Subject: Re: [pgjdbc/pgjdbc] issue #3511: Performance Regression in JDBC Driver 42.7.5 - getCrossReference
In-Reply-To: <gh-pgjdbc-pgjdbc-3511@github.com>
References: <gh-pgjdbc-pgjdbc-3511@github.com>
List-Id: <gh-pgjdbc-pgjdbc.github.com>
X-GitHub-Author-Login: davecramer
X-GitHub-Comment-Id: 2642726101
X-GitHub-Comment-Type: issue_comment
X-GitHub-Issue: 3511
X-GitHub-Repo: pgjdbc/pgjdbc
X-GitHub-Type: comment
X-GitHub-Url: https://github.com/pgjdbc/pgjdbc/issues/3511#issuecomment-2642726101
Content-Type: text/plain; charset=utf-8

Can one of you send me your schema's to test this with? The only thing that really changed in the query is 
```
Key Differences:
First Query:

Uses NULL::text AS PKTABLE_CAT and NULL::text AS FKTABLE_CAT, meaning these columns will always be NULL.
Second Query:

Uses current_database() AS "PKTABLE_CAT" and current_database() AS "FKTABLE_CAT", meaning these columns will contain the name of the current database.
```