Matthew Sullivan wrote:
The OS is FreeBSD 5.4-RELEASE-p14 The PG Version is 8.1.3 Solutions/tips greatly appreciated.
This won't help this particular query, but 6.1-RELEASE will possibly be a better performer generally, in particular for your SMP system - e.g. the vfs layer is no longer under the Giant lock in the 6.x series, so parallel io should be much better!
Cheers Mark
