We've completed some tests comparing Postgres 8.2beta1 (beta1) and Postgres 8.2beta1 with strlcpy () (strlcpy).
First and foremost, the patch seems to be stable - we have not run into any issues with it.
After a database reload, there is an 11% difference between strlcpy and beta1 - strlcpy (107 TPS) performing ~11%
betterthan beta1 (96 TPS). This seems to be consistent over a number of runs. Originally, we had only seen 3%
differencehere.
After 8 (or so) runs, the difference between the two versions disappears and both versions produce ~250 TPS. Both
versions,over time, spend more and more time in LWLockAcquire.
David