Horton

Re: What exactly is postgres doing during INSERT/UPDATE ?

Pierre C <lists@peufeu.com>

View thread
From: Pierre Frédéric Caillaud <lists@peufeu.com>
To: "Joseph S" <jks@selectacast.net>, pgsql-performance@postgresql.org
Date: 2009-08-28T07:52:33Z
Lists: pgsql-performance 
> top shows the cpu usage of the pg process ranges from zero to never more  
> than ten percent of a cpu, and that one cpu is always ninety some odd  
> percent in iowait.  So what is postgres doing (with fsync off) that  
> causes the cpu to spend so much time in iowait?

	Updating indexes ?