From: Bruce Momjian <bruce@momjian.us>
To: Luca Ferrari <fluca1978@gmail.com>
Cc: Thomas Munro <thomas.munro@gmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: FreeBSD UFS & fsync
Date: Thu, 11 Mar 2021 09:29:45 -0500
Message-ID: <20210311142945.GB2469@momjian.us> (raw)
In-Reply-To: <CAKoxK+7sjq-WhedUFfaBT8svW+-F4tb11fM1xsWo+7LvusRhwg@mail.gmail.com>
References: <CAKoxK+5mb7X6+ojzufJQb_s-way4ntjtOG+bbMtifGrccirYGg@mail.gmail.com>
<CA+hUKG+0DWFSZTGmezxZttXTy0YYrX=oemxiw8Gzz3hSTU64Jw@mail.gmail.com>
<CAKoxK+7PgBe=38ZBJk3z7Qp7erMV9cG7Rx10uUPAorjpC+aVhA@mail.gmail.com>
<CAKoxK+7sjq-WhedUFfaBT8svW+-F4tb11fM1xsWo+7LvusRhwg@mail.gmail.com>
On Tue, Feb 23, 2021 at 12:57:22PM +0100, Luca Ferrari wrote:
> On Tue, Feb 23, 2021 at 8:46 AM Luca Ferrari <fluca1978@gmail.com> wrote:
> > I'm using sata disks, not scsi. Assuming I'm not looking at the wrong
> > parameter, I wil attach a scsi disk to do the same test and see if
> > something changes.
>
> I've tested the same version of PostgreSQL, same benchmark, on a scsi
> disk. However, turning off fsync does not provide any increment at all
> (something that spans in less than 1% tps).
> I've checked and I have WCE enabled on such disk, but apparently I
> cannot modify (I suspect this is due to the virtualization of the
> disk):
You should really be running pg_test_fsync for this kind of testing.
--
Bruce Momjian <bruce@momjian.us> https://momjian.us
EDB https://enterprisedb.com
The usefulness of a cup is in its emptiness, Bruce Lee
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: bruce@momjian.us, fluca1978@gmail.com, thomas.munro@gmail.com
Subject: Re: FreeBSD UFS & fsync
In-Reply-To: <20210311142945.GB2469@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