Postgres Pro
Downloads
Home   >   mailing lists

Re: What exactly is postgres doing during INSERT/UPDATE ? - Mailing list pgsql-performance

From Pierre Frédéric Caillaud
Subject Re: What exactly is postgres doing during INSERT/UPDATE ?
Date
Msg-id op.uzc35vvbcke6l8@soyouz
Whole thread Raw
In response to What exactly is postgres doing during INSERT/UPDATE ?  (Joseph S <jks@selectacast.net>)
List pgsql-performance
Tree view 
> 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 ?

pgsql-performance by date:

Previous
From: Joseph S
Date:
Subject: What exactly is postgres doing during INSERT/UPDATE ?
Next
From: Greg Smith
Date:
Subject: Re: What exactly is postgres doing during INSERT/UPDATE ?