"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

Reply via email to