On 2022-08-08 Mo 11:07, Marcos Pegoraro wrote: > > What platform is this on? Is it possible that on some platform the > chunk > size we're using is not doing an atomic write? > > > Until last year we were Ubuntu 16.04 and Postgres 11 with the latest > minor update. > This January we changed to Ubuntu 20.04 and Postgres 14, now updated > to 14.4. > > But the problem occured on both old and new SO and Postgres versions. > Right now I opened the current log file and there are 20 or 30 of > these statements and all of them are fine, maybe tomorrow the problem > comes back, maybe this afternoon. > >
OK, we really need a repeatable test if possible. Perhaps a pgbench run with lots of concurrent runs of a some very long query would do the trick. cheers andrew -- Andrew Dunstan EDB: https://www.enterprisedb.com
