jakob / jakob/Postico

structure view performance degrades with large column count

Open
#6 1 comment 3 reactions 0 assignees View on GitHub
bug
Dominant language
Python
Stars
486
Forks
8
PR merge metrics
No merged PRs in 30d

Description

while the content view for large tables performs better than any other postgres app, the structure view performance degrades noticeably for tables with more than 40 columns. Adding additional columns takes longer for each new column. To reproduce just create a new table and hit the `+ Column` button a bunch of times. After `column50` it takes 3 seconds on my macbook air for the new column to appear, after `column70` the app starts to beachball for a while.

Contributor guide

No contributing guide indexed for this repository

Research direction

Reproduce the slowdown in the structure view by creating a table and repeatedly using the `+ Column` button. Observe the time to add columns around column50 and column70, then trace the structure-view column-add path. Done means adding columns no longer degrades noticeably or beachballs with large column counts.

Written by the indexing model from the issue text.

Assessment

Tech stack
postgres
Domain
database, performance
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
25/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.