Re: [PERFORM] Network permormance under windows (fwd) - Mailing list pgsql-hackers

From Qingqing Zhou
Subject Re: [PERFORM] Network permormance under windows (fwd)
Date
Msg-id Pine.LNX.4.58.0512031940180.13561@eon.cs
Whole thread Raw
List pgsql-hackers
Is there any reports/fix of this problem?

Regards,
Qingqing

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 *"?
> >


pgsql-hackers by date:

Previous
From: Simon Riggs
Date:
Subject: Re: Reducing relation locking overhead
Next
From: "Qingqing Zhou"
Date:
Subject: Re: Reducing relation locking overhead