Message-ID: <gh-pgjdbc-pgjdbc-3505-c2631634653@github.com>
From: "labkey-tchad (@labkey-tchad)" <noreply+labkey-tchad@github.com>
To: "pgjdbc/pgjdbc" <noreply+pgjdbc-pgjdbc@github.com>
Date: Mon, 03 Feb 2025 17:31:02 +0000
Subject: Re: [pgjdbc/pgjdbc] issue #3505: Metadata queries are much slower after update to 24.7.5
In-Reply-To: <gh-pgjdbc-pgjdbc-3505@github.com>
References: <gh-pgjdbc-pgjdbc-3505@github.com>
List-Id: <gh-pgjdbc-pgjdbc.github.com>
X-GitHub-Author-Login: labkey-tchad
X-GitHub-Comment-Id: 2631634653
X-GitHub-Comment-Type: issue_comment
X-GitHub-Issue: 3505
X-GitHub-Repo: pgjdbc/pgjdbc
X-GitHub-Type: comment
X-GitHub-Url: https://github.com/pgjdbc/pgjdbc/issues/3505#issuecomment-2631634653
Content-Type: text/plain; charset=utf-8

> hmmm 2700 ms doesn't seem right. Thanks for the report. Dave

2700ms is the total for fetching metadata for 117 different tables. Each table takes around 30ms (compared to 5ms with the 24.7.4 driver)
The full texts of the queries are hidden under the expandos above (e.g. "24.7.5 query")