| From: | "Rajesh Kumar Mallah(dot)" <mallah(at)trade-india(dot)com> |
|---|---|
| To: | Björn Lundin <bjorn(dot)lundin(at)swipnet(dot)se>, pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: speeding up \d commands. |
| Date: | 2002-08-23 16:04:58 |
| Message-ID: | 200208232134.58970.mallah@trade-india.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
Hi,
Vacuum what ? which tables
also i read somewhere that postgres need to be started in a standalone mode,
is that so?
regds
mallah/
On Friday 23 August 2002 12:23, Björn 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örn
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
--
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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dmitry Tkach | 2002-08-23 17:09:20 | 'on delete' rule: bug or feature... |
| Previous Message | Ross J. Reedstrom | 2002-08-23 15:01:34 | Re: SELECT ... WHERE ... NOT IN (SELECT ...); |