Re: postgresql and process titles

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 jnasby(at)pervasive(dot)com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461