From: Craig Ringer <craig@postnewspapers.com.au>
To: Robert Haas <robertmhaas@gmail.com>
Cc: Eduardo Piombino <drakorg@gmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: a heavy duty operation on an "unused" table kills my server
Date: Thu, 14 Jan 2010 13:36:54 +0800
Message-ID: <4B4EAD76.9030305@postnewspapers.com.au> (raw)
In-Reply-To: <603c8f071001130823l69804fe3m5c6fbb081c55c265@mail.gmail.com>
References: <e24c1d9d1001122059ic5d4721o98ccf85033b1fead@mail.gmail.com>
<4B4D5698.8040808@emolecules.com>
<e24c1d9d1001122147l1c0e2111kce25dc2c7f393087@mail.gmail.com>
<4B4D61DA.7080008@postnewspapers.com.au>
<e24c1d9d1001122303g1d4eea48h18bd73467d1fa8ec@mail.gmail.com>
<603c8f071001130823l69804fe3m5c6fbb081c55c265@mail.gmail.com>
Robert Haas wrote:
> I'm kind of surprised that there are disk I/O subsystems that are so
> bad that a single thread doing non-stop I/O can take down the whole
> server. Is that normal?
No.
> Does it happen on non-Windows operating
> systems?
Yes. My 3ware 8500-8 on a Debian Sarge box was so awful that launching a
terminal would go from a 1/4 second operation to a 5 minute operation
under heavy write load by one writer. I landed up having to modify the
driver to partially mitigate the issue, but a single user on the
terminal server performing any sort of heavy writing would still
absolutely nuke performance.
I landed up having dramatically better results by disabling the
controller's RAID features, instead exposing each disk to the OS
separately and using Linux's software RAID.
> What kind of hardware should I not buy to make sure this
> doesn't happen to me?
3ware's older cards. Apparently their new ones are a lot better, but I
haven't verified this personally.
Anything in RAID-5 without a BBU.
Anything at all without a BBU, preferably.
--
Craig Ringer
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: craig@postnewspapers.com.au, robertmhaas@gmail.com, drakorg@gmail.com
Subject: Re: a heavy duty operation on an "unused" table kills my server
In-Reply-To: <4B4EAD76.9030305@postnewspapers.com.au>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox