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

From: Pierre Frédéric Caillaud <lists(at)peufeu(dot)com>
To: "Joseph S" <jks(at)selectacast(dot)net>, pgsql-performance(at)postgresql(dot)org
Subject: Re: What exactly is postgres doing during INSERT/UPDATE ?
Date: 2009-08-28 07:52:33
Message-ID: op.uzc35vvbcke6l8@soyouz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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 ?

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Greg Smith 2009-08-28 08:08:15 Re: What exactly is postgres doing during INSERT/UPDATE ?
Previous Message Joseph S 2009-08-28 06:56:23 What exactly is postgres doing during INSERT/UPDATE ?