Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id A746C476461 for ; Fri, 23 Aug 2002 12:01:28 -0400 (EDT) Received: from mail-relay.trade-india.com (mail-relay.trade-india.com [203.196.129.235]) by postgresql.org (Postfix) with SMTP id 4BDED476115 for ; Fri, 23 Aug 2002 12:01:25 -0400 (EDT) Received: (qmail 18986 invoked from network); 23 Aug 2002 15:50:58 -0000 Received: from system67.trade-india-local.com (192.168.0.67) by infocom-236-129-del.trade-india.com with SMTP; 23 Aug 2002 15:50:58 -0000 Content-Type: text/plain; charset="iso-8859-1" From: "Rajesh Kumar Mallah." Organization: Infocom Network Limited. To: =?iso-8859-1?q?Bj=F6rn=20Lundin?= , pgsql-sql@postgresql.org Subject: Re: speeding up \d commands. Date: Fri, 23 Aug 2002 21:34:58 +0530 User-Agent: KMail/1.4.1 References: <200208231010.50935.mallah@trade-india.com> In-Reply-To: MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable Message-Id: <200208232134.58970.mallah@trade-india.com> X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200208/326 X-Sequence-Number: 9172 Hi, Vacuum what ? which tables also i read somewhere that postgres need to be started in a standalone mod= e, is that so? regds mallah/ On Friday 23 August 2002 12:23, Bj=F6rn Lundin wrote: > Rajesh Kumar Mallah. wrote: > > Hi , > > > > Is there any way to speed up the \d commands issued to psql. > > eg vaccuming the system catalogs etc. (will it help ) > > vacuum / vacuum analyze as the postgre user > > /Bj=F6rn > > ---------------------------(end of broadcast)--------------------------- > TIP 6: Have you searched our list archives? > > http://archives.postgresql.org --=20 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.