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.