On Wed, Nov 22, 2023 at 03:25:07PM +1300, Thomas Munro wrote: > On Wed, Nov 22, 2023 at 2:12 PM Bruce Momjian <br...@momjian.us> wrote: > > On Sat, Aug 12, 2017 at 10:47:00PM +0100, John Ekins wrote: > > > Sure. Camcontrol does indeed cover IDE, SCSI and SAS drives. > > > > > > Replace this line: > > > On FreeBSD, IDE drives can be queried using atacontrol... > > > > > > With this: > > > On FreeBSD, IDE drives can be queried using camcontrol identify... > > > > > > In other words, the query is the same as for SCSI drives. For > > > verification this > > > is what the output looks like: > > > > > > root@bsd11desk:/home/jre # camcontrol identify 0:0:0 | egrep > > > "Feature|write > > > cache" > > > Feature Support Enabled Value Vendor > > > write cache yes yes > > > > > > I appreciate the Postgresql docs are not meant to be FreeBSD tutorials. > > > > I know this email is six years old, but I have applied this fix to all > > supported Postgres versions. A huge apology for this delay. > > It's funny that we discuss IDE drives at all. They stopped being > manufactured a decade ago and are not supported by modern chipsets or > boards etc[1]. I've been meaning to do something about that, but I > didn't have enough round tuits to research what to write about current > storage technologies... but also in the case of FreeBSD, it doesn't > let you turn the write cache on and off with nvmecontrol yet, but > someone has a relevant patch out (D32700) so I was also waiting for > that to go somewhere before writing in...
I don't think it is safe to disable the nvme cache since it is a cache and a staging area. If you turn it off, it will burn out the chips over time. -- Bruce Momjian <br...@momjian.us> https://momjian.us EDB https://enterprisedb.com Only you can decide what is important to you.
