From: | "Takahashi, Ryohei" <r(dot)takahashi_2(at)jp(dot)fujitsu(dot)com> |
---|---|
To: | "Tsunakawa, Takayuki" <tsunakawa(dot)takay(at)jp(dot)fujitsu(dot)com>, 'Magnus Hagander' <magnus(at)hagander(dot)net>, 'Noah Misch' <noah(at)leadboat(dot)com> |
Cc: | Robert Haas <robertmhaas(at)gmail(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | RE: Too many logs are written on Windows (LOG: could not reserve shared memory region (addr=%p) for child %p:) |
Date: | 2018-12-10 02:15:07 |
Message-ID: | EE586BE92A4AFB45B03310C2A0C0565D6D33EA05@G01JPEXMBKW03 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Hi Noah, Magnus and Tsunakawa-san,
Thank you for replying.
> Can you adopt pgbouncer, to reduce
> the frequency of starting new backend processes? That should improve your
> performance, too.
Actually, before I found that F-secure causes this message,
I recommend my customer to use connection pooling to reduce the number of connection times.
> Could you collect the information
> http://postgr.es/m/20181203053506.GB2860387@rfd.leadboat.com requests?
> That may help us understand your system's unusual behavior. (The issue in that
> thread is related but not identical.)
Sorry. Since my customer uses PostgreSQL in production environment,
I cannot deploy debug modules.
> In this particular case, it seems it *was* helpful, no? That's how you found
> out the customer used a broken antivirus product, which may certainly also
> cause *other* issues.
>
> Some sort of rate limiting to reduce the volume might help, but the message
> itself seems to have clearly been useful.
Yes. You are right.
The message itself was useful.
Your idea to reduce the volume seems good.
> We can change pgwin32_ReserveSharedMemoryRegion() to take an argument "int
> loglevel". Then the caller first calls it with LOG, and DEBUGx afterwards.
> It may also be helpful for the caller to output "LOG: tried %d times to
> reserve shared memory region" when the caller ran the function twice or
> more before success. That explains the possibly long time or CPU spikes
> of connection establishment.
It seems good idea for me.
Regards,
Ryohei Takahashi
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Paquier | 2018-12-10 02:22:09 | Re: Should new partitions inherit their tablespace from their parent? |
Previous Message | Tsunakawa, Takayuki | 2018-12-10 02:03:37 | RE: Statement-level rollback |