question about performance of libpq

From: "Lee Riquelmei" <lestat(dot)pgsql(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: question about performance of libpq
Date: 2006-06-20 15:30:49
Message-ID: cc52f1070606200830x38e12a90kf539fb831bd5d965@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

hi,all. A strange question is as follows:

I have two PCs:
machine A: FreeBSD 5.4 with PostgreSQL 8.1.2
machine B: Windows XP with PostgreSQL 8.1.2

A and B are with same hardware configuration and in a 100Mbit LAN.

a large table "lineitem" about 600572 rows exists in both A and B.

On machine B, i run psql and issue a sql "select * from lineitem" to A:
the execution time is about 10s.
On machine A, i run psql and issue

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Martijn van Oosterhout 2006-06-20 15:31:07 Re: join on next row
Previous Message Jasbinder Bali 2006-06-20 15:23:33 Help requd in writing functions in C and using in Postgres