jakob / jakob/Postico

The app hangs while viewing structure for large tables

Open
#591 2 comments 0 reactions 0 assignees View on GitHub
Dominant language
Python
Stars
485
Forks
8
PR merge metrics
No merged PRs in 30d

Description

While trying to view structure of a table with large number of columns ( 512+ ) the application hangs and takes a while to respond.

All that time I see a busy icon.

Works well for tables with smaller number of columns ( < 20 )

**Postico version:**
1.4.2

**macOS version:**
macOS Sierra v 10.12.4

**PostgreSQL version:**
PostgreSQL 8.0.2 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.4.2 20041017 (Red Hat 3.4.2-6.fc3), Redshift 1.0.3906

Contributor guide

No contributing guide indexed for this repository

Research direction

Reproduce structure viewing with a table containing 512 or more columns, comparing it with a table under 20 columns. Use the reported Postico 1.4.2, macOS Sierra 10.12.4, and PostgreSQL environment as context. Done means the structure view responds without hanging or showing a prolonged busy state for large tables.

Written by the indexing model from the issue text.

Assessment

Tech stack
postgresql, python
Domain
database, desktop
Issue type
Bug
Difficulty
3/5
Estimated time
1-2 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.