From: | Andreas Pflug <pgadmin(at)pse-consulting(dot)de> |
---|---|
To: | Michael Shapiro <mshapiro(at)ncsa(dot)edu> |
Cc: | pgadmin-support(at)postgresql(dot)org |
Subject: | Re: PgAdmin 3 startup |
Date: | 2003-12-29 22:42:58 |
Message-ID: | 3FF0ADF2.3030103@pse-consulting.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
Michael Shapiro wrote:
> I have downloaded the latest snapshot of pgadmin3
> (pgadmin3-20031228-Win32.zip) and connected to a database. PgAmin
> takes 150 seconds to complete its startup.
>
>2003-12-29 15:16:26 QUERY : Scalar query (delphi:5432):
>
SELECT COUNT(*) FROM
(SELECT tgargs from pg_trigger tr
LEFT JOIN pg_depend dep ON dep.objid=tr.oid AND deptype = 'i'
LEFT JOIN pg_constraint co ON refobjid = co.oid AND contype = 'f'
WHERE co.oid IS NULL
GROUP BY tgargs
HAVING count(1) = 3) AS foo
>2003-12-29 15:16:26 QUERY : DEBUG: StartTransactionCommand
>
>2003-12-29 15:18:52 QUERY : DEBUG: CommitTransactionCommand
>
>2003-12-29 15:18:52 QUERY : Query result: 0
>
>
Apparently this query is the offending one. It really should finish
quite fast.
I wonder if you a) have a lot of unmigrated constraint triggers and/or
b) a lot of tables and never vacuumed the system tables.
Please check this and give some feedback.
Regards,
Andreas
From | Date | Subject | |
---|---|---|---|
Next Message | vidhya | 2003-12-30 03:51:19 | switching postgres from windows to linux |
Previous Message | Andreas Pflug | 2003-12-29 22:38:00 | Re: pgadmin bug |