"Jim C. Nasby" <jnasby(at)pervasive(dot)com> 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