On Tue, Feb 23, 2021 at 12:57:22PM +0100, Luca Ferrari wrote: > On Tue, Feb 23, 2021 at 8:46 AM Luca Ferrari <fluca1...@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 <br...@momjian.us> https://momjian.us EDB https://enterprisedb.com The usefulness of a cup is in its emptiness, Bruce Lee
