Re: FileFallocate misbehaving on XFS - Mailing list pgsql-hackers

From Michael Harris
Subject Re: FileFallocate misbehaving on XFS
Date
Msg-id CADofcAWeD4uFPjk8Tee+wxFbaoa30hEENs+JQXg24+uaoKVD1A@mail.gmail.com
Whole thread Raw
In response to Re: FileFallocate misbehaving on XFS  (Andres Freund <andres@anarazel.de>)
List pgsql-hackers
Hi Andres

On Wed, 1 Jan 2025 at 02:31, Andres Freund <andres@anarazel.de> wrote:
> Note that there's
> a) a few hours between messages, whereas previous they were more frequent
> b) f_bfree increased substantially.
>
> I assume that somewhere around 2AM some script prunes old partitions?

Correct.
Data is imported continuously, and the pruning is typically scheduled for 02:00.
In general the events do seem more frequent when the FS is more full.

On Fri, 3 Jan 2025 at 01:40, Andres Freund <andres@anarazel.de> wrote:
> FWIW, I raised this on the #xfs irc channel. One ask they had was:
>
> │15:56:40  dchinner | andres: can you get a metadump of a filesystem that is displaying these symptoms for us to
analyse?
> │15:57:54  dchinner | metadumps don't contain data, and metadata is obfuscated so no filenames or attributes are
exposed,either. 

I'm on leave from work at the moment, but I will try to collect this
when I'm back.

Cheers
Mike



pgsql-hackers by date:

Previous
From: vignesh C
Date:
Subject: Re: Logical Replication of sequences
Next
From: Tatsuo Ishii
Date:
Subject: Re: Proposal: add new API to stringinfo