Re: Turning on archive_mode by default - Mailing list pgsql-pkg-yum

From Peter Eisentraut
Subject Re: Turning on archive_mode by default
Date
Msg-id c7c7ff68-8986-c14c-d5b8-bda2e255bfbb@2ndquadrant.com
Whole thread Raw
In response to Turning on archive_mode by default  (Devrim Gündüz <devrim@gunduz.org>)
Responses Re: Turning on archive_mode by default  (Stephen Frost <sfrost@snowman.net>)
List pgsql-pkg-yum
On 2020-05-20 16:21, Devrim Gündüz wrote:
> Does anyone know whether there is an overhead of turning on
> archive_mode, and setting archive_command to /bin/true?

The overhead is probably small, but what this would do is start the 
archiver and report to stats views etc. that archiving is running and 
progressing, even though it's doing nothing.  That seems pretty bogus 
and confusing.

Most users[citation needed] don't even use archiving anymore, so this is 
the wrong end of history to be fiddling with this setting.

-- 
Peter Eisentraut              http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services



pgsql-pkg-yum by date:

Previous
From: Stephen Frost
Date:
Subject: Re: Can we stop defaulting to 'ident'?
Next
From: Peter Eisentraut
Date:
Subject: Re: Can we stop defaulting to 'ident'?