Re: [pgadmin-support] Slow connect due to some queries

2010-01-18 Thread Guillaume Lelarge
Le 15/01/2010 00:30, Tzvi R a écrit : > [...] > A quick overview of our database server: > * Four databases. > * Each database has about 20 schemas. > > > The largest database contains: > * select count(*) from pg_class where relkind = 'v' >101 > * select count(*) from pg_class where relkind

Re: [pgadmin-support] Slow connect due to some queries

2010-01-14 Thread Tzvi R
Hi, A quick overview of our database server: * Four databases. * Each database has about 20 schemas. The largest database contains: * select count(*) from pg_class where relkind = 'v' 101 * select count(*) from pg_class where relkind = 'r' 11911 (about 500 tables in each schema, I know,

Re: [pgadmin-support] Slow connect due to some queries

2010-01-14 Thread Guillaume Lelarge
Hi, Le 13/01/2010 17:16, Tzvi R a écrit : > [...] > I've been using pgAdmin for a long time but over time it has become more and > more frustrating to use it. > It's a great application that performs everything I need, however, when first > connecting to servers with many databases, each with ma