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

[vijayprasanna13]

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]

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]

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]

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!