On Wednesday, January 11, 2012 11:07:23 AM Kirill Müller wrote: > Hi all, > > we have a Postgres/PostGIS database with 100+ schemas and 200+ tables in > each schema, generated automatically. When adding a new PostGIS layer in > QGis, the application obviously enumerates all tables, and this takes > minutes. Even browsing the database in pgAdmin3 is horribly slow -- it > takes several seconds to e.g. open a schema (click on a schema's "+" in > the tree view). Are you actually sure its the database and not just pgadmin thats getting really slow?
If you connect via psql and use \dt (see \? for a list of commands) and consorts, is it that slow as well? Andres -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
