strange slow performance

From: michael(dot)guiard(at)gmail(dot)com
To: pgsql-general(at)postgresql(dot)org
Subject: strange slow performance
Date: 2006-12-15 12:58:21
Message-ID: 1166187501.548486.12320@73g2000cwn.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi !
I have a strange slow performance problem depending on client computer.
I have a postgresql server (8.1.3) running on an XP system (P4 3GHz,
1Go RAM).

I have 3 other computers from which I make request on the database : 2
XP(named 1 & 2) and 1 2K.

>From one XP(1) and from the 2K computer, I have no slow performance
problem. I ask for a select of 4000 records, the request is processed
in less than 1 seconde.
>From the last XP (2) computer, the same request takes more than 10
seconds. From this computer I have no other network problem, I can
copy, paste network files without any performance problem.

The 3 clients use odbc driver 8.01.02.00.

I tried to install the postgre sql server on the xp (2) and make the
same request from 3 other computers : no problem, the process takes
less than 1 second from all clients

what goes wrong ??
thanks for your help

Mike

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Arturo Perez 2006-12-15 13:26:16 Re: [pgsql-www] Subcribing to this list, what's the
Previous Message Ragnar 2006-12-15 12:49:48 Re: Needed files - embedded postgres