Select slow over network

From: "Leodinei Bielak" <leodinei(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Select slow over network
Date: 2006-11-17 19:22:47
Message-ID: 9ce36bc80611171122i26f2e382ue514904888906cc0@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello. I'm using PostgreSQL 8.1.4 with WinXP Sp2.
The acess over network 100mbit is too slow.
My query take 100 times more.
The use of CPU and network is low, less than 1%.
Searching in the web I found other with the same problem, but no reply to
resolve this problem.
The query is a simple "SELECT * FROM table".
the EXPLAIN of the query:
Seq Scan on cliente_geral (cost=0.00..344.95 rows=6795 width=587)

Thanks.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Thomas H. 2006-11-17 19:43:35 Re: Cannot rename file pg_xlog\0000.....
Previous Message brian 2006-11-17 18:51:35 tracking errors in psql