From: Bruce Momjian <bruce@momjian.us>
To: Thomas Munro <thomas.munro@gmail.com>
Cc: John Ekins <jrekins@gmail.com>
Cc: Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Cc: pgsql-docs@postgresql.org
Subject: Re: [DOCS] The reference to 'atacontrol' on FreeBSD is outdated.
Date: Tue, 21 Nov 2023 21:36:31 -0500
Message-ID: <ZV1pL9R2keCJUXfb@momjian.us> (raw)
In-Reply-To: <CA+hUKGL3EBp56Ebj8M18Z+i7t-0w3R6V8JKgkc69iQpDvMh2mQ@mail.gmail.com>
References: <20170808224017.8424.69170@wrigleys.postgresql.org>
<29e222a6-fd45-e049-ac5c-6bcba6ecdfd0@2ndquadrant.com>
<E1F09343-9031-4351-9837-1C5FA8055A7E@gmail.com>
<ZV1VW0T5WhAYzXNR@momjian.us>
<CA+hUKGL3EBp56Ebj8M18Z+i7t-0w3R6V8JKgkc69iQpDvMh2mQ@mail.gmail.com>
On Wed, Nov 22, 2023 at 03:25:07PM +1300, Thomas Munro wrote:
> On Wed, Nov 22, 2023 at 2:12 PM Bruce Momjian <bruce@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 <bruce@momjian.us> https://momjian.us
EDB https://enterprisedb.com
Only you can decide what is important to you.
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-docs@postgresql.org
Cc: bruce@momjian.us, thomas.munro@gmail.com, jrekins@gmail.com, peter.eisentraut@2ndquadrant.com
Subject: Re: [DOCS] The reference to 'atacontrol' on FreeBSD is outdated.
In-Reply-To: <ZV1pL9R2keCJUXfb@momjian.us>
* 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