On Mon, Oct 10, 2022 at 5:40 PM Robert Haas <robertmh...@gmail.com> wrote: > > On Mon, Oct 10, 2022 at 5:16 AM Dilip Kumar <dilipbal...@gmail.com> wrote: > > I have also executed my original test after applying these patches on > > top of the 56 bit relfilenode patch. So earlier we saw the WAL size > > increased by 11% (66199.09375 kB to 73906.984375 kB) and after this > > patch now the WAL generated is 58179.2265625. That means in this > > particular example this patch is reducing the WAL size by 12% even > > with the 56 bit relfilenode patch. > > That's a very promising result, but the question in my mind is how > much work would be required to bring this patch to a committable > state?
Right, the results are promising. I have done some more testing with make installcheck WAL size (fpw=off) and I have seen a similar gain with this patch. 1. Head: 272 MB 2. 56 bit RelfileLocator: 285 MB 3. 56 bit RelfileLocator + this patch: 261 MB -- Regards, Dilip Kumar EnterpriseDB: http://www.enterprisedb.com
