Postgres Pro
Downloads
Home   >   mailing lists

Re: why select count(*) consumes wal logs - Mailing list pgsql-general

From Thomas Kellerer
Subject Re: why select count(*) consumes wal logs
Date
Msg-id 921d1c6d-e8b1-b171-0959-d62ebc1c3cc4@gmx.net
Whole thread Raw
In response to Re: why select count(*) consumes wal logs  (Ravi Krishna <srkrishna1@aol.com>)
List pgsql-general
Tree view 
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")

pgsql-general by date:

Previous
From: David Gauthier
Date:
Subject: Re: recursion in plpgsql
Next
From: Andrew Gierth
Date:
Subject: Re: recursion in plpgsql