search

hasura / graphql-engine

Blazing fast, instant realtime GraphQL APIs on your DB with fine grained access control, also trigger webhooks on database events.
https://hasura.io
Apache License 2.0
31.09k stars 2.76k forks source link

Databases with a large number of partitions (100+) causes the console to freeze #9509

Open vijayprasanna13 opened 1 year ago

vijayprasanna13 commented 1 year ago

Version Information

Server Version: latest oss

Environment

OSS/Cloud/EE

What is the current behaviour?

Database schemas with lot of partitions causes the console UI to become unresponsive and throw alerts.

What is the expected behaviour?

The Manage Database section of the console should work as expected and list the untracked tables.

How to reproduce the issue?

  1. Track a database with 100+ partitions.
  2. Navigate to the Manage Database section (click on the database name on the nav tree).
  3. The UI becomes unresponsive while trying to load the list of untracked tables.

Any possible solutions/workarounds you're aware of?

  1. Hide the partitions while listing untracked tables in Manage Database section.
  2. Add pagination to the list of tables.

Keywords

console, performance, postgres

manasag commented 1 year ago

New UI that efficiently handle large schemas is now available in v2.29.

How to enable this feature? Navigate to the Settings > Feature Flags part of the console and toggle the Enable new Table Tracking UI for Postgres & SQL Server feature flag to start using this feature.

marionschleifer commented 1 year ago

Hey folks, we will give a short update on this in our community call this Thursday, 27th July at 9am PT, along with many other exciting feature updates 🎉 sign up here if you're interested.

vijayprasanna13 commented 1 year ago

Hey folks! We've added a new experimental version of the Data Tab to handle larger schemas. You can try it out starting from v2.33.0-beta.1 by enabling the feature flag. Please follow this discussion for more updates and do share your early feedback with us!