\d commands over slow connections!

From: "Rajesh Kumar Mallah(dot)" <mallah(at)trade-india(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: \d commands over slow connections!
Date: 2002-09-26 18:26:43
Message-ID: 200209262356.43547.mallah@trade-india.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin


Hi folks,

Hi \d is very slow over slow connections.

I was asked to VACUUM as user postgres but i think
problem is not there. (its still slow for me)

I think it is becuase psql sends a series
of SQLs to construct the result from the server.

This is revealed when we do psql -E.

The more the number of feilds in the more are the queries
and enven slower the final results come.

will it not be a good idea to have the these queries executed
on the server side itself instead of psql sending across them
one by one over the slow links. This will make \d commands
much faster over slow connections.

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.

Browse pgsql-admin by date

  From Date Subject
Next Message Steve Wolfe 2002-09-26 20:27:27 Re: hardware question
Previous Message Andrew Sullivan 2002-09-26 18:01:42 Re: hardware question