Re: [PERFORM] Network permormance under windows (fwd)

On Fri, 2 Dec 2005, Josep Maria Pinyol Fontseca wrote:

Yes, with psql, pgAdminIII and our application with ODBC I experiment
the same situation... the sentences that I execute are like "select *
..." or similar like this.

Qingqing Zhou wrote:

"Josep Maria Pinyol Fontseca" <jmpinyol@endepro.com> wrote

When we select all data in local machine, we obtain results in 2-3 seconds
aprox. In remote connections:

Postgresql 7.1 usign pgAdminII:
Network traffic generated with remote applications is about 77-80% in a
10Mb connection.
6 seconds aprox.

Postgresql 8.1 usign pgAdminIII:
Network traffic generated with remote applications is about 2-4% in a 10Mb
connection.
12 seconds or more...

Have you tried to use psql? And how you "select all data" - by "select
count(*)" or "select *"?