pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feed From: Craig Ringer <craig@postnewspapers.com.au>
To: Ben Chobot <bench@silentmedia.com>
Cc: Ryan Wexler <ryan@iridiumsuite.com>
Cc: PostgreSQL - Performance <pgsql-performance@postgresql.org>
Subject: Re: performance on new linux box
Date: Fri, 16 Jul 2010 19:17:53 +0800
Message-ID: <4C403FE1.8080209@postnewspapers.com.au> (raw )
In-Reply-To: <A6461AB5-0812-4C86-9BF4-3C0EA36148A7@silentmedia.com >
References: <AANLkTinVrej5r_uF3As3mF8BW4CYgLGiw2-v2HORsqjM@mail.gmail.com >
<4C360677.1090608@emolecules.com >
<AANLkTiny431UE-qThjeJuGRst2gR0lkdn1UKKTSWfvV9@mail.gmail.com >
<AANLkTin24rAdlEMpohzAVdBXuI37DPofZrpnKxiQLPgL@mail.gmail.com >
<95971335.20100708211351@erwied.eu >
<AANLkTinsne2dhyxzXBb4KMVM_7yixWaUfVtG-WBPxMIq@mail.gmail.com >
<488953776.20100708213233@erwied.eu >
<AANLkTimx5Ug2iAQLv3l5scscART_6fm-wCl10k1nWyti@mail.gmail.com >
<4C35E4CA020000250003327E@gw.wicourts.gov >
<AANLkTino2ep4VyJDA9PVV6FObxHnBlLX3O9z8q19PzfN@mail.gmail.com >
<4C363CAE.7010401@emolecules.com >
<B9A709F368FAAF4DB4B33870F72A141D0106C0E8@CORPUSMX30A.corp.emc.com >
<4C36462E.1080405@emolecules.com >
<A8F 65D92-00A9-433F-83C0-04DEB55D57DF@silentmedia.com >
<0BC62364-BD19-41E0-A483-677474CD5A5D@richrelevance.com >
<6A7F9A16-F50B-43AE-B349-174726564292@silentmedia.com >
<AANLkTilIaUg3-ethCx_a86HY1PoaT1ZbB1kG7Rxka5tq@mail.gmail.com >
<A6461AB5-0812-4C86-9BF4-3C0EA36148A7@silentmedia.com >
On 16/07/10 06:18, Ben Chobot wrote:
> There are also caches on all your disk drives. Write caching there is always dangerous, which is why almost all raid cards always disable the hard drive write caching, with or without a BBU. I'm not even sure how many raid cards let you enable the write cache on a drive... hopefully, not many.
AFAIK Disk drive caches can be safe to leave in write-back mode (ie
write cache enabled) *IF* the OS uses write barriers (properly) and the
drive understands them.
Big if.
--
Craig Ringer
view thread (50+ messages) latest in thread
Message-ID: <4C403FE1.8080209@postnewspapers.com.au>
Permalink: ../4C403FE1.8080209@postnewspapers.com.au/
Also on: postgresql.org/message-id/4C403FE1.8080209@postnewspapers.com.au
copy link · copy postgr.es
reply 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, bench@silentmedia.com, ryan@iridiumsuite.com
Subject: Re: performance on new linux box
In-Reply-To: <4C403FE1.8080209@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