jakob / jakob/Postico

perfomance degradation for large view definitions

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

Description

There seems to be something going wrong with the structure view for views with large/complex queries.

Viewing the structure of `information_schema.routines` vs `information_schema.sequences` i a good example. `routines` is noticeably slow compared to `sequences` on my machine (2016 15'' MacBook Pro).

Contributor guide

No contributing guide indexed for this repository

Research direction

No file, test, or entry point is named. First reproduce the structure view for information_schema.routines and information_schema.sequences, then trace the code used to load and display large or complex view definitions. Done means identifying and fixing the cause of the noticeable performance difference and verifying both examples again.

Written by the indexing model from the issue text.

Assessment

Tech stack
postgresql
Domain
databases, 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.