| From: | Andres Freund <andres(at)anarazel(dot)de> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Cc: | Kirill Müller <kirill(dot)mueller(at)ivt(dot)baug(dot)ethz(dot)ch> |
| Subject: | Re: Enumeration of tables is very slow in largish database |
| Date: | 2012-01-11 13:44:33 |
| Message-ID: | 201201111444.34049.andres@anarazel.de |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Guillaume Lelarge | 2012-01-11 13:50:32 | Re: pgAdmin - Query - out of memory for query result |
| Previous Message | Guillaume Lelarge | 2012-01-11 13:41:41 | Re: Enumeration of tables is very slow in largish database |