The following bug has been logged online:
Bug reference: 4316
Logged by: blueos
Email address: blueos(at)free(dot)fr
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