Re: Enumeration of tables is very slow in largish database
От | Guillaume Lelarge |
---|---|
Тема | Re: Enumeration of tables is very slow in largish database |
Дата | |
Msg-id | 1326289986.2300.17.camel@localhost.localdomain обсуждение исходный текст |
Ответ на | Re: Enumeration of tables is very slow in largish database (Andres Freund <andres@anarazel.de>) |
Ответы |
Re: Enumeration of tables is very slow in largish database
|
Список | pgsql-general |
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. -- Guillaume http://blog.guillaume.lelarge.info http://www.dalibo.com PostgreSQL Sessions #3: http://www.postgresql-sessions.org
В списке pgsql-general по дате отправления: