From: | Radovan Jablonovsky <radovan(dot)jablonovsky(at)replicon(dot)com> |
---|---|
To: | pgadmin-support(at)postgresql(dot)org |
Subject: | pgadmin retrieving details about schema (700 objects) more than 5min |
Date: | 2012-04-20 22:40:19 |
Message-ID: | CAJYcdTvzfTfCoeW5m7GEadp47-jYrtKRm+JVdZs54PbOAxAi5w@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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 <http://www.facebook.com/Replicon.inc> |
twitter<http://twitter.com/Replicon>
| blog <http://www.replicon.com/blog/> | contact
us<http://www.replicon.com/about_replicon/contact_us.aspx>
From | Date | Subject | |
---|---|---|---|
Next Message | Colin Beckingham | 2012-04-21 09:15:21 | 1.15 Database Designer and character varying length option |
Previous Message | Guillaume Lelarge | 2012-04-20 21:40:44 | Re: dev 1.15, wxw 2.9.3 - index column name truncated by 1 char |