On Mon, Feb 14, 2022 at 9:17 PM Ashutosh Sharma <ashu.coe...@gmail.com> wrote: > > > Is it possible to see the WAL size generated by these two statements: > UPDATE 70% of the tuple in the base table (dirty 70% of the shared > buffers) && CREATE database using template DB (Actual test target). > Just wanted to know if it can exceed the max_wal_size of 64GB.
I think we already know the wal size generated by creating a db with an old and new approach. With the old approach it is just one WAL log and with the new approach it is going to log every single block of the database. Yeah the updating 70% of the database could have some impact but for verification purposes I tested without the update and still the create db with WAL log is taking almost the same time. But anyway when I test next time I will verify again that no force checkpoint is triggered. -- Regards, Dilip Kumar EnterpriseDB: http://www.enterprisedb.com
