[pgadmin-hackers] 10k Tables and more

From: Joao De Almeida Pereira <jdealmeidapereira(at)pivotal(dot)io>
To: pgadmin-hackers <pgadmin-hackers(at)postgresql(dot)org>
Cc: Matthew Kleiman <mkleiman(at)pivotal(dot)io>
Subject: [pgadmin-hackers] 10k Tables and more
Date: 2017-07-17 18:08:17
Message-ID: CAE+jjanj7-DwOWRFwemyOxPQr59EDJBgaBy06Ab2cVzfXX7A4A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-hackers

Hi Hackers,
We were looking at a schema that had 10k+ tables on it and we noticed a
substantial decrease of performance while loading the tables and after they
are loaded and we try to scroll over them.

After some search on the web we found a post of the ACITree maintainer here
<https://disqus.com/home/discussion/acoderinsights/acitree_tree_view_cu_jquery_acoderinsightsro/#comment-1270448772>
and he states that the library was not meant to handle that amount of data.

> Still, with whatever optimizations I'll be able to implement, 10k items
> seem allot on one level. On a slow hardware you'll still have to wait
> enough to get them created, scrolling will also be a problem ... I think.

Is it a common scenario to have an extremely large number of tables?
We wanted to bring up this issue to solicit ideas for ways to improve the
performance of large lists of tables in the ACITree.

Thanks,
João and Matt

Responses

Browse pgadmin-hackers by date

  From Date Subject
Next Message Joao De Almeida Pereira 2017-07-17 18:51:28 [pgadmin-hackers][pgaweb][Patch] Add style guide to pga website
Previous Message Surinder Kumar 2017-07-17 16:57:08 Re: [pgAdmin4]: Webpacking of static JS/CSS