Re: [PERFORM] Very slow INFORMATION_SCHEMA

Mario Weilguni <[EMAIL PROTECTED]> writes: > I can confirm this for a quite larger result set (4020 rows) for a DB > with 410 tables and a lot of foreign key constraints. > ... > This is Postgresql 8.2.4, on a Dual-Core XEON 3.6GHz. With nested_loops > off, I get a very fast response (330ms). FW

Re: [PERFORM] Very slow INFORMATION_SCHEMA

Tom Lane schrieb: Ernesto <[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_COLUM

Re: [PERFORM] Very slow INFORMATION_SCHEMA

Ernesto <[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

[PERFORM] Very slow INFORMATION_SCHEMA

Hi, I'm porting an application written with pretty portable SQL, but tested almost exclusively on MySQL. I'm wondering why would this query take about 90 seconds to return 74 rows? SELECT INFORMATION_SCHEMA.TABLE_CONSTRAINTS.CONSTRAINT_NAME, INFORMATION_SCHEMA.TABLE_CONSTRAINTS.TABLE_NAME,