| Lists: | pgsql-hackers |
|---|
| From: | Qingqing Zhou <zhouqq(at)cs(dot)toronto(dot)edu> |
|---|---|
| To: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: [PERFORM] Network permormance under windows (fwd) |
| Date: | 2005-12-04 00:40:55 |
| Message-ID: | Pine.LNX.4.58.0512031940180.13561@eon.cs |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | 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(at)endepro(dot)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 *"?
> >