"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 *"?
Regards,
Qingqing