> Oh, OK. I am on a dual, so maybe that's why I see an improvement. > If I can get another BSD guy to test this, I can remove the pipe for > all the BSD's.
When benchmarking FreeBSD via worldstone, -pipe makes a difference (how much remains a debate). Since PostgreSQL's compile is small enough, it's likely that many folks won't notice any appreciable difference (though it does add up). Here's a thread worth reading from the gcc guys: http://gcc.gnu.org/ml/gcc-bugs/2000-10/msg00138.html -sc -- Sean Chittenden ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
