Re: can't handle large number of INSERT/UPDATEs
От | Iain |
---|---|
Тема | Re: can't handle large number of INSERT/UPDATEs |
Дата | |
Msg-id | 003a01c4bbe2$36ffe700$7201a8c0@mst1x5r347kymb обсуждение исходный текст |
Ответ на | Re: can't handle large number of INSERT/UPDATEs (Curtis Zinzilieta <curtisz@norchemlab.com>) |
Список | pgsql-performance |
Turbo linux 7 sems to be agreeing with Curtis, bi: ブロックデバイスに送られたブロック (blocks/s)。 bo: ブロックデバイスから受け取ったブロック (blocks/s)。 Sorry it's in Japanese but bi says "blocks sent to block device" and bo is "blocks received from block device". I don't know that much about it but the actual output seems to suggest that the man page is wrong. I find it just the slightest bit amusing that such errors in the docs should be translated faithfully when translating invariably introduces errors of it's own ;) Regards Iain ----- Original Message ----- From: "Tom Lane" <tgl@sss.pgh.pa.us> To: "Curtis Zinzilieta" <curtisz@norchemlab.com> Cc: "Anjan Dave" <adave@vantage.com>; "Matt Clark" <matt@ymogen.net>; "Rod Taylor" <pg@rbt.ca>; "Postgresql Performance" <pgsql-performance@postgresql.org> Sent: Wednesday, October 27, 2004 12:21 PM Subject: Re: [PERFORM] can't handle large number of INSERT/UPDATEs > Curtis Zinzilieta <curtisz@norchemlab.com> writes: >> On Tue, 26 Oct 2004, Tom Lane wrote: >>> Er ... it *is* the other way around. bi is blocks in (to the CPU), >>> bo is blocks out (from the CPU). > >> Ummm..... >> [curtisz@labsoft T2]$ man vmstat >> bi: Blocks sent to a block device (blocks/s). >> bo: Blocks received from a block device (blocks/s). > > You might want to have a word with your OS vendor. My vmstat > man page says > > IO > bi: Blocks received from a block device (blocks/s). > bo: Blocks sent to a block device (blocks/s). > > and certainly anyone who's been around a computer more than a week or > two knows which direction "in" and "out" are customarily seen from. > > regards, tom lane > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Don't 'kill -9' the postmaster
В списке pgsql-performance по дате отправления: