Skip site navigation (1) Skip section navigation (2)

Re: Application bottlenecks

From: Hasns-Juergen Schoenig <postgres(at)cybertec(dot)at>
To: Carlos Henrique Reimer <carlosreimer(at)yahoo(dot)com(dot)br>
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: Application bottlenecks
Date: 2005-09-08 16:47:02
Message-ID: 715FC5E7-2CEE-4C13-80F2-7FAB9FEA50D7@cybertec.at (view raw or flat)
Thread:
Lists: pgsql-odbc
Reimer,

Did you use Windows XP or Windows 2000?

     Best regards,

         Hans


Am 07.09.2005 um 13:24 schrieb Carlos Henrique Reimer:

> Hello,
>
> We are using Cobol Microfocus and pgsqlODBC to access Postgresql.
>
> Originally these applications only accessed Oracle databases  
> without ODBC, only Procobol and now we´re migrating to Postgresql   
> and ODBC. The application logic doesn´t changed, but some  
> applications have higher response times than the Oracle version. We  
> worked on database tunning but even so, the response times are very  
> different.
>
> I turned on logging sql statemants in the server (log_duration) and  
> discovered that the sum of all SQL duration times gives only 30% of  
> the total response time felt at the client. This gives me a suspect  
> that the bottleneck is outside the server.
>
> Am I in the right way?
>
> How can I discover the SQL duration times at the client? Is there  
> some tool I could use?
>
> Thanks in advance!
>
> Reimer
>
> Yahoo! Messenger com voz: PROMOÇÃO VOCÊ PODE LEVAR UMA VIAGEM NA  
> CONVERSA. Participe!

In response to

pgsql-odbc by date

Next:From: Merlin MoncureDate: 2005-09-08 17:07:12
Subject: Re: Application bottlenecks
Previous:From: Merlin MoncureDate: 2005-09-08 13:18:45
Subject: Re: Application bottlenecks

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group