Thread: strange slow performance
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
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 : > 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 > > > ---------------------------(end of broadcast)--------------------------- > TIP 3: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faq