Re: postgresql and process titles - Mailing list pgsql-hackers

From Jim C. Nasby
Subject Re: postgresql and process titles
Date
Msg-id 20060614024856.GX34196@pervasive.com
Whole thread Raw
In response to Re: postgresql and process titles  ("Marc G. Fournier" <scrappy@postgresql.org>)
List pgsql-hackers
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@pervasive.com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: postgresql and process titles
Next
From: Tom Lane
Date:
Subject: Re: CSV mode option for pg_dump