strange slow performance

On Fri, 2006-12-15 at 04:58 -0800, michael.guiard@gmail.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

Hi Jeff !
thanks for your help

The slow part is (I think) the reception part. The connection speed is
excellent. The problem does not come from ODBC driver.
I tried to do my request (select * from ...) with the psql.exe tool and
I have the same result : more than 10 seconds to get the request
result.

where can I check the pg_stat_activity flag ?

Mike

Jeff Davis a �crit :