| From: | Craig Ringer <craig(at)2ndquadrant(dot)com> |
|---|---|
| To: | Robert Haas <robertmhaas(at)gmail(dot)com> |
| Cc: | Kyotaro HORIGUCHI <horiguchi(dot)kyotaro(at)lab(dot)ntt(dot)co(dot)jp>, "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Protect syscache from bloating with negative cache entries |
| Date: | 2016-12-20 14:47:17 |
| Message-ID: | CAMsr+YHziSok-AM=krEQ+HaRQzst4+M1+2WGYqZw_i6w9vVBvA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On 20 December 2016 at 21:59, Robert Haas <robertmhaas(at)gmail(dot)com> wrote:
> We could implement this by having
> some process, like the background writer,
> SendProcSignal(PROCSIG_HOUSEKEEPING) to every process in the system
> every 10 minutes or so.
... on a rolling basis.
Otherwise that'll be no fun at all, especially with some of those
lovely "we kept getting errors so we raised max_connections to 5000"
systems out there. But also on more sensibly configured ones that're
busy and want nice smooth performance without stalls.
--
Craig Ringer http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Fujii Masao | 2016-12-20 14:47:22 | Re: Quorum commit for multiple synchronous replication. |
| Previous Message | Robert Haas | 2016-12-20 14:34:09 | Re: Hang in pldebugger after git commit : 98a64d0 |