The following bug has been logged online: Bug reference: 4316 Logged by: blueos Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3.3 Operating system: Linux Description: 13 seconds to complete SELECT * FROM pg_catalog.pg_attribute Details:
On a server with 5 databases (a schema containing 59 tables and 58 sequences), a SELECT * FROM pg_catalog.pg_attribute takes 13s to complete. It returns 4063 lines. The server is a high end Intel dual core with 4Go of memory, the database is only about 1MB of data! on this machine, a typical query returns in less than 60ms. A strange performance issue. Regards, Guillaume -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
