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

Re: TCP_NO_DELAY & TcpAckFrequency (Re: Slow query through

From: O B <ob(at)kselnet(dot)com>
To: Marc Herbert <Marc(dot)Herbert(at)continuent(dot)com>
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: TCP_NO_DELAY & TcpAckFrequency (Re: Slow query through
Date: 2006-02-20 13:50:01
Message-ID: 43F9C909.7080001@kselnet.com (view raw or flat)
Thread:
Lists: pgsql-odbc
You may try "ethereal" which can give you more details than the TCP
dumps with a structured view of packets and protocol layers.

Olivier.

Marc Herbert wrote:

>Arnaud Lesauvage <thewild(at)freesurf(dot)fr> writes:
>  
>
>>Sure !
>>Here are the two dumps.
>>http://tehwild.free.fr/divers/dumps.zip
>>One is a TCP dump of the query through pgAdmin, the other one
>>through psqlODBC.
>>The first obvious difference is that the window size is not the same,
>>but I don't know how to interpret that.
>>    
>>
>
>The best free tools I know to analyze such issues is tcptrace + xplot
>
><http://www.tcptrace.org/>
>
>
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 9: In versions below 8.0, the planner will ignore your desire to
>       choose an index scan if your joining column's datatypes do not
>       match
>
>
>  
>

In response to

Responses

pgsql-odbc by date

Next:From: Arnaud LesauvageDate: 2006-02-20 13:57:03
Subject: Re: TCP_NO_DELAY & TcpAckFrequency (Re: Slow query through
Previous:From: Marc HerbertDate: 2006-02-20 12:29:15
Subject: Re: TCP_NO_DELAY & TcpAckFrequency (Re: Slow query through

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