| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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
>
>
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Arnaud Lesauvage | 2006-02-20 13:57:03 | Re: TCP_NO_DELAY & TcpAckFrequency (Re: Slow query through |
| Previous Message | Marc Herbert | 2006-02-20 12:29:15 | Re: TCP_NO_DELAY & TcpAckFrequency (Re: Slow query through |