From: | Jeff Davis <pgsql(at)j-davis(dot)com> |
---|---|
To: | michael(dot)guiard(at)gmail(dot)com |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: strange slow performance |
Date: | 2006-12-18 18:48:03 |
Message-ID: | 1166467683.4422.17.camel@dogma.v10.wvs |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Fri, 2006-12-15 at 04:58 -0800, michael(dot)guiard(at)gmail(dot)com wrote:
> 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
>
Try to isolate the problem more closely. What is the actual slow part?
Is it the ODBC operation? The host lookup? The time to establish a
connection? Is the PostgreSQL server actually executing the query for 10
seconds (check pg_stat_activity to see what it's doing)?
Regards,
Jeff Davis
From | Date | Subject | |
---|---|---|---|
Next Message | John McCawley | 2006-12-18 18:57:40 | Re: Creating an Independant Application |
Previous Message | Jeff Davis | 2006-12-18 18:40:41 | Re: Regular expression and Group By |