Обсуждение: pgsql: Ensure that WAL pages skipped by a forced WAL switch arezero-fi

Поиск
Список
Период
Сортировка

pgsql: Ensure that WAL pages skipped by a forced WAL switch arezero-fi

От
Tom Lane
Дата:
Ensure that WAL pages skipped by a forced WAL switch are zero-filled.

In the previous coding, skipped pages were mostly zeroes, but they still
had valid WAL page headers.  That makes them very much less compressible
than an unbroken string of zeroes would be --- about 10X worse for bzip2
compression, for instance.  We don't need those headers, so tweak the logic
so that we zero them out.

Chapman Flack, reviewed by Daniel Gustafsson

Discussion: https://postgr.es/m/579297F8.7020107@anastigmatix.net

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/4a33bb59dfc33566f04e18ab5e1f90b8e7461052

Modified Files
--------------
src/backend/access/transam/xlog.c | 44 ++++++++++++++++++++++++++++-----------
1 file changed, 32 insertions(+), 12 deletions(-)