Re: can't handle large number of INSERT/UPDATEs - Mailing list pgsql-performance

From Matt Clark
Subject Re: can't handle large number of INSERT/UPDATEs
Date
Msg-id 417E9752.5050506@ymogen.net
Whole thread Raw
In response to Re: can't handle large number of INSERT/UPDATEs  ("Anjan Dave" <adave@vantage.com>)
List pgsql-performance
>I don't have iostat on that machine, but vmstat shows a lot of writes to
>the drives, and the runnable processes are more than 1:
>
> 6  1      0 3617652 292936 2791928    0    0     0 52430 1347  4681 25
>19 20 37
>
>
Assuming that's the output of 'vmstat 1' and not some other delay,
50MB/second of sustained writes is usually considered 'a lot'.

pgsql-performance by date:

Previous
From: Josh Berkus
Date:
Subject: Re: can't handle large number of INSERT/UPDATEs
Next
From: Josh Berkus
Date:
Subject: Re: Measuring server performance with psql and pgAdmin