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

Поиск
Список
Период
Сортировка
От Tom Lane
Тема pgsql: Ensure that WAL pages skipped by a forced WAL switch arezero-fi
Дата
Msg-id E1f20Ti-0002BY-In@gemulon.postgresql.org
обсуждение исходный текст
Список pgsql-committers
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(-)


В списке pgsql-committers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: pgsql: Remove obsolete SLRU wrapping and warnings from predicate.c.
Следующее
От: Tom Lane
Дата:
Сообщение: pgsql: Fix bogus provolatile/proparallel markings on a few built-infun