Tom Lane wrote: > Andrew Dunstan <[EMAIL PROTECTED]> writes: > > Tom Lane wrote: > >> It'd be interesting to try to gather stats on the length of the delay > >> taken, but I don't see a good way to do that within the current > >> regression-test infrastructure. > > > Have it log something that will appear on the postmaster log but not the > > client log? Buildfarm members mostly post their complete postmaster > > logs, and we could postprocess those. > > I've applied a patch along this line --- it'll emit LOG messages like > > LOG: wait_for_stats delayed 0.112799018621445 seconds
Beluga just failed: http://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=beluga&dt=2007-02-07%2019:30:01 The delay seems too short though: LOG: wait_for_stats delayed 0.000748 seconds -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support ---------------------------(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