Steve Atkins <steve(at)blighty(dot)com> writes:
> So is 15-20 seconds for \d unusual?
Very.
> If so, where should I start looking to see what's broken?
Well, what query plans are used for the queries issued by \d on each
of your two boxes? Have you done ANALYZE or VACUUM ANALYZE lately?
(Out-of-date stats about the system tables might lead the planner to
make a stupid choice of query plan.)
regards, tom lane