Jim C. Nasby wrote: > FWIW, getting turning off stats_command_string substantially reduced > this contention, so it appears the issue is somewhere in the stats code. > This code sends stats messages to a different process via a socket (or > is it UDP?), with the intention that if the system gets heavily loaded > we'll lose some stats in the interest of not bogging down all the > backends. It seems that doesn't work so hot on FreeBSD. :(
I am working on a patch for 8.2 to fix that for all platforms. -- Bruce Momjian http://candle.pha.pa.us EnterpriseDB http://www.enterprisedb.com + If your life is a hard drive, Christ can be your backup. + ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly