Обсуждение: [ADMIN] Performance impact for enabling Log_disconnections

Поиск
Список
Период
Сортировка

[ADMIN] Performance impact for enabling Log_disconnections

От
Sathesh S
Дата:
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".

Thanks

Re: [ADMIN] Performance impact for enabling Log_disconnections

От
Scott Marlowe
Дата:
On Thu, Aug 10, 2017 at 11:56 AM, Sathesh S
<sathesh.sundaram@hotmail.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.