| From: | "Ideriha, Takeshi" <ideriha(dot)takeshi(at)jp(dot)fujitsu(dot)com> |
|---|---|
| To: | "Tsunakawa, Takayuki" <tsunakawa(dot)takay(at)jp(dot)fujitsu(dot)com>, Kyotaro HORIGUCHI <horiguchi(dot)kyotaro(at)lab(dot)ntt(dot)co(dot)jp> |
| Cc: | Andres Freund <andres(at)anarazel(dot)de>, Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>, Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>, Bruce Momjian <bruce(at)momjian(dot)us>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "PostgreSQL Hackers" <pgsql-hackers(at)lists(dot)postgresql(dot)org>, Michael Paquier <michael(dot)paquier(at)gmail(dot)com>, 'Robert Haas' <robertmhaas(at)gmail(dot)com>, "David Steele" <david(at)pgmasters(dot)net>, Craig Ringer <craig(at)2ndquadrant(dot)com> |
| Subject: | RE: Protect syscache from bloating with negative cache entries |
| Date: | 2019-02-22 15:53:35 |
| Message-ID: | 4E72940DA2BF16479384A86D54D0988A6F42847E@G01JPEXMBKW04 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
>From: Tsunakawa, Takayuki
>Ideriha-san,
>Could you try simplifying the v15 patch set to see how simple the code would look or
>not? That is:
>
>* 0001: add dlist_push_tail() ... as is
>* 0002: memory accounting, with correction based on feedback
>* 0003: merge the original 0003 and 0005, with correction based on feedback
Attached are simpler version based on Horiguchi san's ver15 patch,
which means cache is pruned by both time and size.
(Still cleanup function is complex but it gets much simpler.)
Regards,
Takeshi Ideriha
| Attachment | Content-Type | Size |
|---|---|---|
| v15-0003-ideriha-Remove-CatCache-Entries.patch | application/octet-stream | 23.7 KB |
| v15-0002-ideriha-Memory-consumption-report-reature-of-memorycontext.patch | application/octet-stream | 3.6 KB |
| v15-0001-Add-dlist_move_tail.patch | application/octet-stream | 1.2 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Robert Haas | 2019-02-22 15:58:24 | Re: WIP: Avoid creation of the free space map for small tables |
| Previous Message | Robert Haas | 2019-02-22 15:41:02 | Re: libpq debug log |