Re: Loading Data-Types takes quite long

From: Dave Page <dpage(at)pgadmin(dot)org>
To: Andreas Neumann <a(dot)neumann(at)carto(dot)net>
Cc: pgadmin-support(at)postgresql(dot)org
Subject: Re: Loading Data-Types takes quite long
Date: 2009-04-16 15:41:17
Message-ID: 937d27e10904160841k70b923m3e478b515c3455eb@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

On Thu, Apr 16, 2009 at 4:13 PM, Andreas Neumann <a(dot)neumann(at)carto(dot)net> wrote:
> Hi PgAdmin developers,
>
> I have a question concerning the data-type loading when creating a new
> table and adding new columns. On my client-server system it takes quite
> long to bring up the "New Column" dialogue.
>
> My guess is that it looks for new data types (e.g. enums, domains,
> self-created datatypes, etc.) everytime I bring up this dialogue. On my
> setup this can take 10-12 seconds. If I add, say 10-20 new columns this
> can be annoying.
>
> Wouldn't it be possible to cache the datatypes pgadmin found instead of
> looking for new data types for each new column? Maybe only look for new
> types when the new table dialogue comes up - or adding a button to search
> for new data types?
>
> What do you think?

Yes, that would be a good idea. It won't happen for 1.10 though I'm afraid.

--
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com

In response to

Browse pgadmin-support by date

  From Date Subject
Next Message Obe, Regina 2009-04-16 18:33:54 Can't create 8.4 database when specifying collation and character type in 1.10 beta
Previous Message Andreas Neumann 2009-04-16 15:13:28 Loading Data-Types takes quite long