Re: Disk wait problem... may not be hardware...

From: Justin Clift <justin(at)postgresql(dot)org>
To: pf(at)pfortin(dot)com
Cc: pgsql-general(at)lists(dot)postgresql(dot)org, Rick Yost <Rick(at)ncdatateam(dot)org>
Subject: Re: Disk wait problem... may not be hardware...
Date: 2023-10-27 06:22:16
Message-ID: 3c1e3b653ad983bf6bf30b3ea4bd4036@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 2023-10-27 12:03, pf(at)pfortin(dot)com wrote:
<snip>
> I can't think of a common hardware bus/other that would only affect
> PostgreSQL disk accesses.

Which file system is PostgreSQL being run on?

Asking because I remember seeing weirdness reported with *some* SSD
drives when used with ZFS:

https://github.com/openzfs/zfs/discussions/14793

Note - that's not PostgreSQL specific or anything, but more of a
"weird stuff showing up with NVMe drives" thing.

Regards and best wishes,

Justin Clift

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Laurenz Albe 2023-10-27 08:33:48 Re: Correct way of using complex expressions as partitioning key
Previous Message Alexander Rumyantsev 2023-10-27 04:27:54 Correct way of using complex expressions as partitioning key