Re: why select count(*) consumes wal logs

From: Thomas Kellerer <spam_eater(at)gmx(dot)net>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: why select count(*) consumes wal logs
Date: 2018-11-07 14:43:05
Message-ID: 921d1c6d-e8b1-b171-0959-d62ebc1c3cc4@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Ravi Krishna schrieb am 07.11.2018 um 15:10:
>
>> select data_page_checksum_version from pg_control_init()
>
> returned 1. So we have page_checksum turned on, and wal_log_hints off.

If page_checksum is enabled, then wal_log_hints is ignored (or actually always assumed "on")

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Andrew Gierth 2018-11-07 15:17:33 Re: recursion in plpgsql
Previous Message David Gauthier 2018-11-07 14:35:30 Re: recursion in plpgsql