Re: Ragged latency log data in multi-threaded pgbench

Andrew Dunstan <andrew@dunslane.net>

From: Andrew Dunstan <andrew@dunslane.net>
To: Greg Smith <greg@2ndquadrant.com>
Cc: PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2010-03-15T15:58:15Z
Lists: pgsql-hackers

Greg Smith wrote:
> Just noticed a problem popping up sometimes with the new 
> multi-threaded pgbench.  This is on a Linux RPM build (the alpha4 set) 
> compiled with '--disable-thread-safety'.  Still trying to nail down 
> whether that's a requirement for this problem to appear or not.  I did 
> most of my review of this feature with it turned on, and haven't been 
> seeing this problem on other systems that are thread safe.  Not sure 
> yet if that's cause and effect or coincidence yet.
>
>

We had to turn handsprings to prevent this sort of effect with the 
logging collector, which was a requirement of being able to implement 
CSV logging sanely. So I'm not surprised by this report.

cheers

andrew