Hi, Am Mittwoch, den 06.01.2021, 13:19 -0800 schrieb Peter Geoghegan: > On Wed, Jan 6, 2021 at 1:08 PM Peter Geoghegan <p...@bowt.ie> wrote: > > So you tested this using "show data_checksums;" in psql in each case? > > > > What does "show full_page_writes;" show you? > > Another consideration is checkpoint_timeout
That one seems to be 5min everywhere, and one can change it except on Azure. > and max_wal_size. I think this one is usually based on instance size, but I only have access to two differently sized instance on Azure right now, where it is 1GB for the smallest possible one and 32GB for a production instance. It's 1GB for the small Google Cloud SQL Postgres and 2GB for the small RDS test instance. It is user-changeable everywhere (at least to some degree). Michael -- Michael Banck Projektleiter / Senior Berater Tel.: +49 2166 9901-171 Fax: +49 2166 9901-100 Email: michael.ba...@credativ.de credativ GmbH, HRB Mönchengladbach 12080 USt-ID-Nummer: DE204566209 Trompeterallee 108, 41189 Mönchengladbach Geschäftsführung: Dr. Michael Meskes, Jörg Folz, Sascha Heuer Unser Umgang mit personenbezogenen Daten unterliegt folgenden Bestimmungen: https://www.credativ.de/datenschutz
