| 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
| 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 |