Re: \d tablename with psql over slow links... - Mailing list pgsql-admin

From Rajesh Kumar Mallah
Subject Re: \d tablename with psql over slow links...
Date
Msg-id 200302241040.57946.mallah@trade-india.com
Whole thread Raw
In response to Re: \d tablename with psql over slow links...  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
thank you.

On Monday 24 February 2003 09:25 am, Tom Lane wrote:
> <mallah@trade-india.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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html

--

Regds
Mallah

----------------------------------------
Rajesh Kumar Mallah,
Project Manager (Development)
Infocom Network Limited, New Delhi
phone: +91(11)6152172 (221) (L) ,9811255597 (M)

Visit http://www.trade-india.com ,
India's Leading B2B eMarketplace.

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: \d tablename with psql over slow links...
Next
From: "Gaetano Mendola"
Date:
Subject: Re: index not used in ( varchar = text )