Ok, i was thinking from the disk perspective. Thanks!

        -----Original Message----- 
        From: Tom Lane [mailto:[EMAIL PROTECTED] 
        Sent: Tue 10/26/2004 6:37 PM 
        To: Anjan Dave 
        Cc: Matt Clark; Rod Taylor; Postgresql Performance 
        Subject: Re: [PERFORM] can't handle large number of INSERT/UPDATEs 

        "Anjan Dave" <[EMAIL PROTECTED]> writes: 
        > One thing I am not sure is why 'bi' (disk writes) stays at 0 mostly, 
        > it's the 'bo' column that shows high numbers (reads from disk). With so 
        > many INSERT/UPDATEs, I would expect it the other way around... 

        Er ... it *is* the other way around.  bi is blocks in (to the CPU), 
        bo is blocks out (from the CPU). 

                                regards, tom lane 

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
      subscribe-nomail command to [EMAIL PROTECTED] so that your
      message can get through to the mailing list cleanly

Reply via email to