Windows 2000 Slower Than Windows XP

From: "Quinton Lawson" <qlawson(at)adelphia(dot)net>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Windows 2000 Slower Than Windows XP
Date: 2005-01-23 01:57:50
Message-ID: 000801c500ee$f775dc00$6501a8c0@travis
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs pgsql-general

I have been having quite a time trying to figure this one out. I have installed PostgreSQL OLE DB drivers (ver 1.0.0.15) on two separate machines. The only difference between the two machines is the OS, 2000 Pro (SP4) and XP Pro (SP2) and both are fully updated from fresh installs. The PostgreSQL 8.0 server is running on another Windows XP Pro machine (SP2, fully updated).

I am performing a Select query like this:
SELECT column1, column2, column3 FROM table1 WHERE column4 = 'value1' AND column5 ='value2' ORDER BY column1, column2;

Connection String:
Provider=PostgreSQL.1;Password="";User ID=client1;Data Source=server;Location=Media Database;Extended Properties=""

The results take approximately 2 seconds on the XP machine and 8 seconds on the 2000 machine.

Explain Analyze yields nearly identical times (45ms) between the two.

Any ideas why this is occuring?

Thank You,
qlawson

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Joe Audette 2005-01-23 03:47:09 Re: Windows 2000 Slower Than Windows XP
Previous Message Bruce Momjian 2005-01-23 00:41:49 Re: BUG #1414: DOC - pl/Perl hash tags missing

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2005-01-23 02:47:07 Re: "Invalid message format" error from JDBC driver
Previous Message Tom Lane 2005-01-23 01:00:23 Re: pg_restore