PgAdmin startup query VERY slow

Поиск
Список
Период
Сортировка
От Michael Shapiro
Тема PgAdmin startup query VERY slow
Дата
Msg-id 5.2.0.9.2.20040106144745.00bcfe30@pop.ncsa.uiuc.edu
обсуждение исходный текст
Ответы Re: PgAdmin startup query VERY slow  (Josh Berkus <josh@agliodbs.com>)
Список pgsql-performance
I have reported this on the pgadmin-support mailing list, but Andreas Pflug
has asked me to post it here.

With a particular database, PgAdmin3 takes a very long time to connect to a
database. this is not a general problem with PgAdmin, but only with one
database out of many. Other databases do not have the problem. And only
with one particular server. The exact same database on a different server
does not have the problem.

The server in question is running PostgreSQL 7.3.2 on
sparc-sun-solaris2.8,  compiled by GCC 2.95.2

The other server which has the same database is running Postgres 7.3.4 on
i386-redhat-linux-gnu, complied by GCC i386-redhat-linux-gcc 3.2.2.

I have attached the query that Andreas says is the one that is run when
PgAdmin first connects to a database as well as the output from running the
query with explain turned on.

Both Andreas and I would be every interested if this group might have any
ideas why the query is so slow.

NOTE: I have vacuumed the database, but that did not affect the timing at all.
NOTE: The startup on the sparc server is 44 seconds, The startup on the
linux server is 5 seconds.

Andreas writes:
I can't see too much from this query plan, it just seems you have 321
triggers an 4750 dependencies which isn't too extraordinary much. But 48
seconds execution time *is* much.

Please repost this to pgsql-performance, including the query, backend
version, and modified server settings. I'm not deep enough in planner items
to analyze this sufficiently.
Please let me CCd on this topic so I can see what I should change in
pgAdmin3 (if any).



---
Michael


---
Michael

Вложения

В списке pgsql-performance по дате отправления:

Предыдущее
От: Mark Kirkwood
Дата:
Сообщение: Re: Select max(foo) and select count(*) optimization
Следующее
От: Josh Berkus
Дата:
Сообщение: Re: PgAdmin startup query VERY slow