Re: Performance impact for enabling Log_disconnections

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: Sathesh S <sathesh(dot)sundaram(at)hotmail(dot)com>
Cc: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Performance impact for enabling Log_disconnections
Date: 2017-08-10 18:01:25
Message-ID: CAOR=d=0wk=v4T0Pv6ZHZLtHe1uFGN-ZWFQHDaQAeUOpQ6VoJzQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Thu, Aug 10, 2017 at 11:56 AM, Sathesh S
<sathesh(dot)sundaram(at)hotmail(dot)com> wrote:
> Hello All,
>
> I'm trying to understand if there will be any performance impact in the
> database if we enable "log_connections" and "log_disconnections".

The performance impact of those statements is minimal, especially if
you log remotely or to different disks than where your db lives.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Scott Whitney 2017-08-10 18:10:12 Re: Shutdown Order with Primary/Standby?
Previous Message Don Seiler 2017-08-10 17:59:21 Shutdown Order with Primary/Standby?