Re: \d tablename with psql over slow links...

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: mallah(at)trade-india(dot)com
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: \d tablename with psql over slow links...
Date: 2003-02-24 03:55:39
Message-ID: 26640.1046058939@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

<mallah(at)trade-india(dot)com> writes:
> I observed that a table which used to take 16 secs with \d was only taking
> 6 secs if the query for default attribute values are shifted to top level query in
> psql/describe.c ( function describeOneTableDetails ) .

I've applied this patch with some small improvements (to shortcircuit
the sub-SELECT for columns with no default).

regards, tom lane

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Rajesh Kumar Mallah 2003-02-24 05:10:57 Re: \d tablename with psql over slow links...
Previous Message mallah 2003-02-24 03:13:51 Re: \d tablename with psql over slow links...