On Fri, Apr 27, 2018 at 2:55 AM, Olivier Macchioni
wrote:
> Hello all,
>
> PostgreSQL version 9.4.17
>
> We have a number of queries running on the same DB from many systems. Among
> other things, we need to INSERT / UPDATE on a table based on external events
> - this is done via a pool of 5 SQL
Olleg Samoylov writes:
> On 2018-04-27 10:55, Olivier Macchioni wrote:
>> Does anyone have an idea on how to process in such a case?
> Log statments too. :)
Another idea is to get the app to set application_name differently for
each session (and be sure to include %a in log_line_prefix). It mig
> On 27 Apr 2018, at 11:58, Olleg Samoylov wrote:
>
> On 2018-04-27 10:55, Olivier Macchioni wrote:
>> Does anyone have an idea on how to process in such a case?
>>
> Log statments too. :)
>
Thank you - I was afraid of such an answer and on the load it may generate...
I'll give it a try duri
On 2018-04-27 10:55, Olivier Macchioni wrote:
> Does anyone have an idea on how to process in such a case?
>
Log statments too. :)
Hello all,
PostgreSQL version 9.4.17
We have a number of queries running on the same DB from many systems. Among
other things, we need to INSERT / UPDATE on a table based on external events -
this is done via a pool of 5 SQL connections which process an average of 500
events / second. The tabl
