Skip site navigation (1) Skip section navigation (2)

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

From: Rajesh Kumar Mallah <mallah(at)trade-india(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: \d tablename with psql over slow links...
Date: 2003-02-24 05:10:57
Message-ID: 200302241040.57946.mallah@trade-india.com (view raw or flat)
Thread:
Lists: pgsql-admin
thank you.

On Monday 24 February 2003 09:25 am, Tom Lane wrote:
> <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
>
> ---------------------------(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.

In response to

pgsql-admin by date

Next:From: Gaetano MendolaDate: 2003-02-24 08:41:54
Subject: Re: index not used in ( varchar = text )
Previous:From: Tom LaneDate: 2003-02-24 03:55:39
Subject: Re: \d tablename with psql over slow links...

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group