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
