Обсуждение: pgadmin retrieving details about schema (700 objects) more than 5min
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 We are hiring! | search jobs
www.replicon.com | facebook | twitter | blog | contact us