Re: \d on database with a lot of tables is slow

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Jim C(dot) Nasby" <jnasby(at)pervasive(dot)com>
Cc: Hannu Krosing <hannu(at)skype(dot)net>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: \d on database with a lot of tables is slow
Date: 2005-09-28 15:35:31
Message-ID: 6776.1127921731@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

"Jim C. Nasby" <jnasby(at)pervasive(dot)com> writes:
> Sorry, remembered it wrong. It's 'Did not find any relation named',
> which appears to be in bin/psql/describe.c. It does occur when trying to
> do a \d on a specific table.

Hmm, no immediate ideas. You haven't provided a lot of context about
this --- when it happens, is it repeatable? Are they giving an exact
table name or a pattern to \d? Is a schema name included in what they
give to \d? What PG version are they running exactly?

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2005-09-28 15:41:29 Re: enhanced pgbench
Previous Message Bruce Momjian 2005-09-28 15:35:26 Re: [PATCHES] Proposed patch for sequence-renaming problems