\d very, very, very slow

From: Steve Atkins <steve(at)blighty(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: \d very, very, very slow
Date: 2002-08-04 06:05:40
Message-ID: 20020803230540.A28986@blighty.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


I'm seeing very, very slow response to \d <tablename> - around 15-20
seconds on an otherwise idle Netra.

PostgreSQL 7.2.1 on sparc-sun-solaris2.8, compiled by cc -xarch=v9 -Xa

Running psql -E shows that \d is issuing 4 queries. Picking one at
random at running it through explain analyze shows three nested
seqscans and a few joins, taking 6500ms.

(Running the same query on a Linux box running Postgresql 7.2 with the
same schema and similar postgresql.conf shows the same query plan,
taking 80ms.)

So is 15-20 seconds for \d unusual? If so, where should I start looking
to see what's broken?

Any thoughts appreciated.

Cheers,
Steve

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alvaro Herrera 2002-08-04 06:22:14 Re: Are these error messages normal?
Previous Message Tom Lane 2002-08-04 05:51:55 Re: \d very, very, very slow