From: | michael(dot)guiard(at)gmail(dot)com |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: strange slow performance |
Date: | 2006-12-19 13:47:27 |
Message-ID: | 1166536047.792591.169820@48g2000cwx.googlegroups.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(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
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq
From | Date | Subject | |
---|---|---|---|
Next Message | Lincoln Yeoh | 2006-12-19 14:03:09 | Re: Let's play bash the search engine |
Previous Message | Clodoaldo | 2006-12-19 13:37:49 | Re: Regular expression and Group By |