pgadmin retrieving details about schema (700 objects) more than 5min - Mailing list pgadmin-support

From Radovan Jablonovsky
Subject pgadmin retrieving details about schema (700 objects) more than 5min
Date
Msg-id CAJYcdTvzfTfCoeW5m7GEadp47-jYrtKRm+JVdZs54PbOAxAi5w@mail.gmail.com
Whole thread Raw
List pgadmin-support
Hello,

We are using  PgAdmin version 1.14.2, running on Windows 7 Enterprise 64bit, 3.2GHz CPU with 4GB RAM
to connect to postgres 9.1.1 linux x64 on centos 5.8

aspdata=# select version();
                                                    version
---------------------------------------------------------------------------------------------------------------
 PostgreSQL 9.1.1 on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 4.1.2
20080704 (Red Hat 4.1.2-52), 64-bit

We currently have 1 DB we use for multiple independent tenant schemas. The
database size is 27GB. There are 600 schemas each with about 900 objects
(240 tables, 520 views, 140 sequences).

Just to open one schema to browse through tables will take more then 5 minutes.
The same issue is for browsing views.
 
Sincerely,
--

Radovan Jablonovsky | SaaS DBA | Phone 1-403-262-6519 (ext. 256) | Fax 1-403-233-8046


Replicon | Hassle-Free Time & Expense Management Software - 7,300 Customers - 70 Countries
www.replicon.com | facebook | twitter | blog | contact us

We are hiring! | search jobs


pgadmin-support by date:

Previous
From: Guillaume Lelarge
Date:
Subject: Re: dev 1.15, wxw 2.9.3 - index column name truncated by 1 char
Next
From: Colin Beckingham
Date:
Subject: 1.15 Database Designer and character varying length option