Search Postgresql Archives

Re: why select count(*) consumes wal logs

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Subject: Re: why select count(*) consumes wal logs
From: Thomas Kellerer <spam_eater@xxxxxxx>
Date: Wed, 7 Nov 2018 15:43:05 +0100
In-reply-to: <2083098227.299875.1541599822999@mail.yahoo.com>
Newsgroups: gmane.comp.db.postgresql.general
References: <653931906.1147337.1541523848244.ref@mail.yahoo.com> <653931906.1147337.1541523848244@mail.yahoo.com> <26567.1541526011@sss.pgh.pa.us> <CAD+GXYOczcCYKk=6cst5Zn5d8Ew_fYnDtf-kyam6y0qmLE60Mw@mail.gmail.com> <E9FA92C2921F31408041863B74EE4C2001BCB90585@CCPMAILDAG03.cantab.local> <1709325689.226793.1541591667311@mail.yahoo.com> <E9FA92C2921F31408041863B74EE4C2001BCB92BDD@CCPMAILDAG03.cantab.local> <2083098227.299875.1541599822999@mail.yahoo.com>
User-agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.23) Gecko/20090812 Thunderbird/2.0.0.23 Mnenhy/0.7.6.666

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")

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

References:
- why select count(*) consumes wal logs
  - From: Ravi Krishna
- Re: why select count(*) consumes wal logs
  - From: Tom Lane
- Re: why select count(*) consumes wal logs
  - From: Bruno Lavoie
- RE: why select count(*) consumes wal logs
  - From: Steven Winfield
- Re: why select count(*) consumes wal logs
  - From: Ravi Krishna
- RE: why select count(*) consumes wal logs
  - From: Steven Winfield
- Re: why select count(*) consumes wal logs
  - From: Ravi Krishna

Prev by Date: Re: recursion in plpgsql
Next by Date: Re: recursion in plpgsql
Previous by thread: Re: why select count(*) consumes wal logs
Next by thread: Re: why select count(*) consumes wal logs
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Postgresql & PHP] [Yosemite]