View Single Post

   
  #2 (permalink)  
Old 04-16-2008, 02:51 AM
Marc Herbert
 
Posts: n/a
Default Re: TCP_NO_DELAY & TcpAckFrequency (Re: Slow query through

Arnaud Lesauvage <thewild@freesurf.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

Reply With Quote