[Tsung] Re: postgresql testing - authentication / phases / open connections

[Nicolas Niclausse]

Michael Nacos ecrivait le 09.07.2008 18:25:

> more or less, I get approx 100 simultaneous connections, which is what 
> I'd expect, as this is the max_connect pgsql setting.
> but the size_rcv curve is flat, after a certain stage, and anyhow, I'd 
> expect it to be much higher than size_sent.
> 
> the server is under stress, I can certainly see that with ps/top etc., 
> but are the clients getting any results and if yes, why don't I see that 
> in the graphs? (please have a look at graphes-Size-total.png)

This is strange indeed.

Do you have errors (error_pgsql ) ? Maybe there is a problem with the 
requests and the server is responding with very short messages ??


in the logs files, you should have lines like:
=INFO REPORT==== 10-Jul-2008::10:23:02 ===
          ts_pgsql:(5:<0.88.0>) PGSQL: Got Error Msg from postgresql 
[[{severity,
 
'ERROR'},
                                                                          etc.

(loglevel must be at least notice  (or info or debug))

Otherwise, you can start a test with a single client with debug level and 
dumptraffic=true and send me the logfiles )

-- 
Nicolas