Re: \d very, very, very slow

> -----Original Message-----
> From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
> Sent: 04 August 2002 06:52
> To: Steve Atkins
> Cc: pgsql-general@postgresql.org
> Subject: Re: [GENERAL] \d very, very, very slow
>
>
> Steve Atkins <steve@blighty.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.)

We find that sometimes pgadmin takes this long to show us DB details when we
double click on a DB and we vacuum analyse every night.

This ispostgres 7.2.1

Sam