[BUG] Query stuck on "Loading Foreign Keys" in PostgreSQL

[sersh88]

• Database Type and Version: PostgreSQL 15.4

When querying any table, the query gets stuck with the status "Loading database_name#database_name ForeignKeys" and never completes. If I disconnect from the database and reconnect, sometimes queries work normally.

This issue happens only in databases with a large number of tables (over 350), mainly partitioned tables. Disabling the Foreign Key feature does not fix the problem.

Additionally, when trying to list tables for the first time, I often get a "connection timeout". On the second attempt, the tables load, but querying any of them leads to the issue.

[cweijan]

Thanks for your report! I will optimize the performance in the next version. Can you provide the log?

[sersh88]

Nothing in the log.