Re: FreeBSD UFS & fsync

On Tue, Feb 23, 2021 at 12:57:22PM +0100, Luca Ferrari wrote: > On Tue, Feb 23, 2021 at 8:46 AM Luca Ferrari 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 test

Re: Is there a known bug with SKIP LOCKED and "tuple to be locked was already moved to another partition due to concurrent update"?

Hi everyone, Is this a well know bug? I just hit the same issue. Below are steps to reproduce. Create data table and partition it by state CREATE TABLE data ( id bigserial not null, state smallint not null DEFAULT 1, updated_at timestamp without time zone default now() ) partition by l