"Jim C. Nasby" <[EMAIL PROTECTED]> writes: >>> I have a client with a database that contains 4000 relations according >>> to vacuum verbose, and \d in psql is painfully slow. In particular...
It's presumably mostly in the pg_table_is_visible() calls. Not sure if we can do much to speed those up, but: how many schemas in your search path? What's the distribution of pg_class entries among the schemas? regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend