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.
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 |