On Tue, Jun 13, 2006 at 11:13:55PM -0300, Marc G. Fournier wrote: > >BTW, there's another FBSD performance odditiy I've run across. Running > > > >pg_dump -t email_contrib -COx stats | bzip2 > ec.sql.bz2 & > > > >which dumps the email_contrib table to bzip2 then to disk, the OS won't > >use more than 1 CPU on an SMP system... unless the data is cached. > >According to both gstat and systat -v, the system isn't I/O bound; both > >are reporting the RAID10 with that table on it as only about 10% busy. If > >I let that command run for a bit then cancel it and re-start it so that > >the beginning of that table is in cache, it will use one entire CPU for > >bzip2, which is what I'd expect to happen. > > What version of FreeBSD are you dealing with here? I'm guessing at least > 6.x, but just figured I'd clarify ...
FreeBSD 6.0-STABLE #6: Fri Dec 9 19:14:19 UTC 2005 -- Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED] Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461 ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org