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

From Ravi Krishna
Subject Re: why select count(*) consumes wal logs
Date
Msg-id 1709325689.226793.1541591667311@mail.yahoo.com
Whole thread Raw
In response to RE: why select count(*) consumes wal logs  (Steven Winfield <Steven.Winfield@cantabcapital.com>)
Responses RE: why select count(*) consumes wal logs
List pgsql-general
> As long as you don’t have page checksums turned on,
> you can prevent this by turning off wal_log_hints.

  


I did not run initdb. How to find out which parameter were used with initdb. For page checksums
to be on, it must have been run with -k option.

Our wal_log_hints is left at default which means off.

thanks


pgsql-general by date:

Previous
From: Saikumar
Date:
Subject: Re: Postgres 8.3 Grant all on database or schema
Next
From: Adrien NAYRAT
Date:
Subject: Re: ERROR: found multixact from before relminmxid