Re: can't handle large number of INSERT/UPDATEs

From: Matt Clark <matt(at)ymogen(dot)net>
To: Anjan Dave <adave(at)vantage(dot)com>
Cc: Rod Taylor <pg(at)rbt(dot)ca>, Postgresql Performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: can't handle large number of INSERT/UPDATEs
Date: 2004-10-26 18:28:34
Message-ID: 417E9752.5050506@ymogen.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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'.

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Josh Berkus 2004-10-26 19:20:21 Re: Measuring server performance with psql and pgAdmin
Previous Message Josh Berkus 2004-10-26 18:27:02 Re: can't handle large number of INSERT/UPDATEs