Re: Direct I/O - Mailing list pgsql-hackers

From Thomas Munro
Subject Re: Direct I/O
Date
Msg-id CA+hUKG+7ywdJbi+5BgVarapASYYqp9qBPWzRuVzVzhuQ3-dccg@mail.gmail.com
Whole thread Raw
In response to Re: Direct I/O  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On Mon, Apr 10, 2023 at 8:43 AM Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Boy, it's hard to look at that trace and not call it a filesystem bug.

Agreed.

> Given the apparent dependency on COW, I wonder if this has something
> to do with getting confused about which copy is current?

Yeah, I suppose it would require bogus old page versions (or I guess
alternatively completely mixed up page offsets) rather than bogus
zeroed pages to explain the too-high count observed in one of crake's
failed runs: I guess it counted some pre-updated tuples that were
supposed to be deleted and then counted the post-updated tuples on
later pages (insert joke about the Easter variant of the Halloween
problem).  It's just that in the runs I've managed to observe and
analyse, the previous version always happened to be zeros.



pgsql-hackers by date:

Previous
From: Noah Misch
Date:
Subject: Re: Direct I/O
Next
From: Michael Paquier
Date:
Subject: Re: Commitfest 2023-03 starting tomorrow!