Re: Very slow INFORMATION_SCHEMA

Ernesto <equistango@[EMAIL PROTECTED]
> writes:
> I'm wondering why would this query take about 90 seconds to return 74
rows?

EXPLAIN ANALYZE might tell you something.

Is this really the query you're running?  Because these two columns
don't exist:

> INFORMATION_SCHEMA.KEY_COLUMN_USAGE.REFERENCED_TABLE_NAME, 
> INFORMATION_SCHEMA.KEY_COLUMN_USAGE.REFERENCED_COLUMN_NAME

Leaving those out, I get sub-second runtimes for 70-odd foreign key
constraints, on much slower hardware than I think you are using.

			regards, tom lane

-- 
Sent via pgsql-performance mailing list (pgsql-performance@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance