From: | 顾小波 <guxiaobo1982(at)gmail(dot)com> |
---|---|
To: | "'Guillaume Lelarge'" <guillaume(at)lelarge(dot)info> |
Cc: | <pgadmin-support(at)postgresql(dot)org> |
Subject: | Re: It takes a long time for pgAdmin to retrieve database schema details |
Date: | 2010-07-19 13:01:22 |
Message-ID: | 002901cb2742$7fb22fe0$7f168fa0$@com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
Hi Guillaume,
Have you received our DDL database dump?
Xiaobo.Gu
-----Original Message-----
From: Guillaume Lelarge [mailto:guillaume(at)lelarge(dot)info]
Sent: Thursday, July 15, 2010 5:37 AM
To: 顾小波
Cc: pgadmin-support(at)postgresql(dot)org
Subject: Re: [pgadmin-support] It takes a long time for pgAdmin to retrieve database schema details
Le 14/07/2010 17:48, 顾小波 a écrit :
> [...]
> we use gpAdminIII 1.10.3 with Greeenplum database 3.3.5.0 on Solaris X64
> 10u7, one of our databases has 36 schemas, one of which has 716 tables,
> and the whole database size is about 4~5T.
Would it be possible to get a copy of your schema? (not the data of
course, but the objects definition) The idea is to restore them on my
computer, and fix the performance issue you have.
> When users open pgAdminIII
> and click the database node under the Databases node it takes a long
> time for pgAdminIII to “restoring previous environment….”, when users
> click one of the schemas, it also takes a long time for pgAdminIII to
> “retrieving Schema details…”, and the whole Interface is haling, I think
> this is due to this operation is single threaded. Another suggestion is
> can you improve gpAdmin to retrieve as little detail information as
> possible, just to retrieve it when user really need it, especially for
> high cost operations such as select count(*) from table.
>
Yes, it's single threaded. There's not a lot of count(*) uses, mainly on
system catalogs. There's one on the data (which would cause you bad
issues on a 4TB database), but it's only launched if you have bad
statistics.
Regards.
--
Guillaume
http://www.postgresql.fr
http://dalibo.com
From | Date | Subject | |
---|---|---|---|
Next Message | Guillaume Lelarge | 2010-07-19 13:10:47 | Re: It takes a long time for pgAdmin to retrieve database schema details |
Previous Message | 顾小波 | 2010-07-18 13:21:37 | pgAdminIII 1.10.3 can't start in Windows Server 2003 Server 64bit |