From: | Michael Shapiro <mshapiro(at)ncsa(dot)edu> |
---|---|
To: | pgsql-performance(at)postgresql(dot)org |
Subject: | PgAdmin startup query VERY slow |
Date: | 2004-01-06 20:49:16 |
Message-ID: | 5.2.0.9.2.20040106144745.00bcfe30@pop.ncsa.uiuc.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
Attachment | Content-Type | Size |
---|---|---|
expalin.txt | text/plain | 30.1 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Josh Berkus | 2004-01-06 21:01:43 | Re: PgAdmin startup query VERY slow |
Previous Message | Mark Kirkwood | 2004-01-06 19:28:45 | Re: Select max(foo) and select count(*) optimization |