Hi Michael,
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 settin
At 03:09 PM 12/31/2003 +0100, Andreas Pflug wrote:
Michael Shapiro wrote:
At 10:12 PM 12/30/2003 +0100, Andreas Pflug wrote:
Michael,
Michael Shapiro wrote:
The only clue that I might be able to offer you is that we have dropped
and recreated the schemas in the database many many times without
How do I cut and paste the results (in the Data Output window) so I can
send them to you. The normal highlight / cut/paste doesn't seem to work.
At 03:09 PM 12/31/2003 +0100, Andreas Pflug wrote:
Michael Shapiro wrote:
At 10:12 PM 12/30/2003 +0100, Andreas Pflug wrote:
Michael,
Michael Shapiro
Michael Shapiro wrote:
At 10:12 PM 12/30/2003 +0100, Andreas Pflug wrote:
Michael,
Michael Shapiro wrote:
The only clue that I might be able to offer you is that we have
dropped and recreated the schemas in the database many many times
without dropping and recreating the database. Might that
At 10:12 PM 12/30/2003 +0100, Andreas Pflug wrote:
Michael,
Michael Shapiro wrote:
The only clue that I might be able to offer you is that we have dropped
and recreated the schemas in the database many many times without
dropping and recreating the database. Might that cause this query to run
Michael,
*please* use the mailing list!!!
Michael Shapiro wrote:
The only clue that I might be able to offer you is that we have
dropped and recreated the schemas in the database many many times
without dropping and recreating the database. Might that cause this
query to run slowly?
Yes, that
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
