Re: Turning on archive_mode by default

From: Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com>
To: Devrim Gündüz <devrim(at)gunduz(dot)org>, pgsql-pkg-yum <pgsql-pkg-yum(at)postgresql(dot)org>
Subject: Re: Turning on archive_mode by default
Date: 2020-05-20 14:58:56
Message-ID: c7c7ff68-8986-c14c-d5b8-bda2e255bfbb@2ndquadrant.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-pkg-yum by date

  From Date Subject
Next Message Peter Eisentraut 2020-05-20 15:03:32 Re: Can we stop defaulting to 'ident'?
Previous Message Stephen Frost 2020-05-20 14:57:52 Re: Can we stop defaulting to 'ident'?