From: | Matthew Wakeling <matthew(at)flymine(dot)org> |
---|---|
To: | Craig James <craig_james(at)emolecules(dot)com> |
Cc: | Greg Smith <greg(at)2ndquadrant(dot)com>, Andy Colson <andy(at)squeakycode(dot)net>, Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>, pgsql-performance(at)postgresql(dot)org |
Subject: | Re: a heavy duty operation on an "unused" table kills my server |
Date: | 2010-01-15 17:16:54 |
Message-ID: | alpine.DEB.2.00.1001151716000.6195@aragorn.flymine.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
On Fri, 15 Jan 2010, Craig James wrote:
>> That's the perception I get. CFQ is the default scheduler, but in most
>> systems I have seen, it performs worse than the other three schedulers, all
>> of which seem to have identical performance. I would avoid anticipatory on
>> a RAID array though.
>
> I thought the best strategy for a good RAID controller was NOOP.
Agreed. That's what we use here. My observation is though that noop is
identical in performance to anticipatory and deadline. Theoretically, it
should be faster.
Matthew
--
"Take care that thou useth the proper method when thou taketh the measure of
high-voltage circuits so that thou doth not incinerate both thee and the
meter; for verily, though thou has no account number and can be easily
replaced, the meter doth have one, and as a consequence, bringeth much woe
upon the Supply Department." -- The Ten Commandments of Electronics
From | Date | Subject | |
---|---|---|---|
Next Message | Pierre Frédéric Caillaud | 2010-01-15 18:00:11 | Re: new server I/O setup |
Previous Message | Alan McKay | 2010-01-15 17:16:33 | Re: OT: Db2 connection pooling? |