On Wed, 2012-01-11 at 15:10 +0100, Andres Freund wrote: > On Wednesday, January 11, 2012 02:53:06 PM Guillaume Lelarge wrote: > > On Wed, 2012-01-11 at 14:44 +0100, Andres Freund wrote: > > > 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? > > > > \dt won't be as slow as pgAdmin. \dt only gets the table name, owner, > > and stuff like that. Kinda quick. pgAdmin will get also all the other > > informations, like columns, triggers, constraints, functions, types, > > etc. > Yes, sure. My guess is that the gui/pgadmin is the bottleneck and not postgres > itself. Its hard to really do all what pgadmin does at once inside psql > though. > Yeah, sure enough. -- Guillaume http://blog.guillaume.lelarge.info http://www.dalibo.com PostgreSQL Sessions #3: http://www.postgresql-sessions.org -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
