Protect syscache from bloating with negative cache entries

Edit
Comment/Review
Change Status
ID 931
Title Protect syscache from bloating with negative cache entries
Topic Performance
Created 2016-12-26 08:44:40
Last modified 2021-10-05 16:21:07 (3 years, 1 month ago)
Latest email 2021-03-24 05:26:44 (3 years, 7 months ago)
Status
2021-09: Returned with feedback
2021-07: Moved to next CF
2021-03: Moved to next CF
2021-01: Moved to next CF
2020-11: Moved to next CF
2020-09: Moved to next CF
2020-07: Moved to next CF
2020-03: Moved to next CF
2020-01: Moved to next CF
2019-11: Moved to next CF
2019-09: Moved to next CF
2019-07: Moved to next CF
2019-03: Moved to next CF
2019-01: Moved to next CF
2018-11: Moved to next CF
2018-09: Moved to next CF
2018-07: Moved to next CF
2018-03: Moved to next CF
2018-01: Moved to next CF
2017-11: Moved to next CF
2017-09: Moved to next CF
2017-03: Moved to next CF
2017-01: Moved to next CF
Target version
Authors Kyotaro Horiguchi (horiguti)
Reviewers Jim Nasby (decibel), Takeshi Ideriha (ideriha), Takayuki Tsunakawa (maumau), Heikki Linnakangas (heikki)Become reviewer
Committer
Links CFbot results (CirrusCI) CFbot GitHub Wiki
Checkout latest CFbot patchset Go to your local checkout of the PostgreSQL repository and run: 
git remote add commitfest https://github.com/postgresql-cfbot/postgresql.git
git fetch commitfest cf/931
git checkout commitfest/cf/931
Emails
Protect syscache from bloating with negative cache entries
First at 2016-12-19 11:15:05 by Kyotaro HORIGUCHI <horiguchi.kyotaro at lab.ntt.co.jp>
Latest at 2021-03-24 05:26:44 by Kyotaro Horiguchi <horikyota.ntt at gmail.com>
Latest attachment (v9-0001-CatCache-expiration-feature.patch) at 2021-01-28 07:50:44 from Kyotaro Horiguchi <horikyota.ntt at gmail.com>
    Attachment (v9-0001-CatCache-expiration-feature.patch) at 2021-01-28 07:50:44 from Kyotaro Horiguchi <horikyota.ntt at gmail.com> (Patch: Yes)
    Attachment (v8-0001-CatCache-expiration-feature.patch) at 2021-01-27 11:11:55 from Heikki Linnakangas <hlinnaka at iki.fi> (Patch: Yes)
    Attachment (v7-0001-CatCache-expiration-feature.patch) at 2021-01-27 01:13:08 from Kyotaro Horiguchi <horikyota.ntt at gmail.com> (Patch: Yes)
    Attachment (catcachebench_master.diff) at 2021-01-27 01:07:47 from Kyotaro Horiguchi <horikyota.ntt at gmail.com> (Patch: Yes)
    Attachment (v6-0001-CatCache-expiration-feature.patch) at 2021-01-14 08:32:27 from Kyotaro Horiguchi <horikyota.ntt at gmail.com> (Patch: Yes)
    Attachment (v5-0001-CatCache-expiration-feature.patch) at 2020-11-19 05:25:36 from Kyotaro Horiguchi <horikyota.ntt at gmail.com> (Patch: Yes)
    Attachment (v5-0001-CatCache-expiration-feature.patch) at 2020-11-09 09:34:47 from Kyotaro Horiguchi <horikyota.ntt at gmail.com> (Patch: Yes)
    Attachment (v4-0001-CatCache-expiration-feature.patch) at 2020-11-06 08:29:58 from Kyotaro Horiguchi <horikyota.ntt at gmail.com> (Patch: Yes)
    Attachment (v3-0001-base_change.patch) at 2020-11-05 07:26:55 from Kyotaro Horiguchi <horikyota.ntt at gmail.com> (Patch: Yes)
    Attachment (v2-0001-base_change.patch) at 2020-10-01 07:47:18 from Kyotaro Horiguchi <horikyota.ntt at gmail.com> (Patch: Yes)
    Attachment (v1-0001-base_change.patch) at 2020-01-22 05:38:19 from Kyotaro Horiguchi <horikyota.ntt at gmail.com> (Patch: Yes)
    Attachment (0001-catcache-benchmark-extension.patch) at 2020-01-14 03:49:32 from Kyotaro Horiguchi <horikyota.ntt at gmail.com> (Patch: Yes)
    Attachment (0001-benchmark.patch) at 2019-11-19 10:48:10 from Kyotaro Horiguchi <horikyota.ntt at gmail.com> (Patch: Yes)
    Attachment (v18-0001-Adjust-inlining-of-some-functions.patch) at 2019-07-01 07:02:59 from Kyotaro Horiguchi <horikyota.ntt at gmail.com> (Patch: Yes)
    Attachment (palloc_bench.gz) at 2019-04-11 06:27:05 from "Ideriha, Takeshi" <ideriha.takeshi at jp.fujitsu.com> (Patch: No)
    Attachment (v17-0001-Remove-entries-that-haven-t-been-used-for-a-certain-.patch) at 2019-04-05 08:32:12 from Kyotaro HORIGUCHI <horiguchi.kyotaro at lab.ntt.co.jp> (Patch: Yes)
    Attachment (0001-Remove-entries-that-haven-t-been-used-for-a-certain-.patch) at 2019-04-05 00:44:07 from Kyotaro HORIGUCHI <horiguchi.kyotaro at lab.ntt.co.jp> (Patch: Yes)
    Attachment (0001-Remove-entries-that-haven-t-been-used-for-a-certain-.patch) at 2019-04-04 12:52:55 from Kyotaro HORIGUCHI <horiguchi.kyotaro at lab.ntt.co.jp> (Patch: Yes)
    Attachment (LRU-0001-Add-dlist_move_tail.patch) at 2019-03-29 08:24:40 from Kyotaro HORIGUCHI <horiguchi.kyotaro at lab.ntt.co.jp> (Patch: Yes)
    Attachment (v15-0001-3-Add-dlist_move_tail.patch) at 2019-03-04 03:03:51 from "Ideriha, Takeshi" <ideriha.takeshi at jp.fujitsu.com> (Patch: Yes)
    Attachment (v18-0001-Add-dlist_move_tail.patch) at 2019-03-01 08:32:45 from Kyotaro HORIGUCHI <horiguchi.kyotaro at lab.ntt.co.jp> (Patch: Yes)
    Attachment (v15-0001-2-Add-dlist_move_tail.patch) at 2019-02-25 11:05:08 from "Ideriha, Takeshi" <ideriha.takeshi at jp.fujitsu.com> (Patch: Yes)
    Attachment (v15-0003-ideriha-Remove-CatCache-Entries.patch) at 2019-02-22 15:53:35 from "Ideriha, Takeshi" <ideriha.takeshi at jp.fujitsu.com> (Patch: Yes)
    Attachment (v16-0001-Add-dlist_move_tail.patch) at 2019-02-20 04:14:35 from Kyotaro HORIGUCHI <horiguchi.kyotaro at lab.ntt.co.jp> (Patch: Yes)
    Attachment (v15-0001-Add-dlist_move_tail.patch) at 2019-02-13 06:31:14 from Kyotaro HORIGUCHI <horiguchi.kyotaro at lab.ntt.co.jp> (Patch: Yes)
    Attachment (v14-0001-Add-dlist_move_tail.patch) at 2019-02-12 11:36:28 from Kyotaro HORIGUCHI <horiguchi.kyotaro at lab.ntt.co.jp> (Patch: Yes)
    Attachment (run-data.sh) at 2019-02-09 18:09:59 from Tomas Vondra <tomas.vondra at 2ndquadrant.com> (Patch: No)
    Attachment (v13-0001-Add-dlist_move_tail.patch) at 2019-02-07 12:18:45 from Kyotaro HORIGUCHI <horiguchi.kyotaro at lab.ntt.co.jp> (Patch: Yes)
    Attachment (v12-0001-Add-dlist_move_tail.patch) at 2019-02-07 06:24:18 from Kyotaro HORIGUCHI <horiguchi.kyotaro at lab.ntt.co.jp> (Patch: Yes)
    Attachment (v11-0001-Remove-entries-that-haven-t-been-used-for-a-certain-.patch) at 2019-02-06 08:37:04 from Kyotaro HORIGUCHI <horiguchi.kyotaro at lab.ntt.co.jp> (Patch: Yes)
    Attachment (v10-0001-Remove-entries-that-haven-t-been-used-for-a-certain-.patch) at 2019-02-06 06:17:59 from Kyotaro HORIGUCHI <horiguchi.kyotaro at lab.ntt.co.jp> (Patch: Yes)
    Attachment (v9-0001-Remove-entries-that-haven-t-been-used-for-a-certain-.patch) at 2019-02-06 05:43:34 from Kyotaro HORIGUCHI <horiguchi.kyotaro at lab.ntt.co.jp> (Patch: Yes)
    Attachment (v8-0001-Remove-entries-that-haven-t-been-used-for-a-certain-.patch) at 2019-01-23 08:35:02 from Kyotaro HORIGUCHI <horiguchi.kyotaro at lab.ntt.co.jp> (Patch: Yes)
    Attachment (add_v7-0001-Remove-entries-that-haven-t-been-used-for-a-certain-.patch) at 2019-01-21 07:48:02 from Kyotaro HORIGUCHI <horiguchi.kyotaro at lab.ntt.co.jp> (Patch: Yes)
    Attachment (v7-0001-Remove-entries-that-haven-t-been-used-for-a-certain-.patch) at 2019-01-18 08:33:30 from Kyotaro HORIGUCHI <horiguchi.kyotaro at lab.ntt.co.jp> (Patch: Yes)
    Attachment (refactor-sinval-msg-IDs-1.patch) at 2019-01-13 16:39:25 from Tom Lane <tgl at sss.pgh.pa.us> (Patch: Yes)
    Attachment (v6-0001-Remove-entries-that-haven-t-been-used-for-a-certain-.patch) at 2018-11-27 10:36:22 from Kyotaro HORIGUCHI <horiguchi.kyotaro at lab.ntt.co.jp> (Patch: Yes)
    Attachment (0001-Remove-entries-that-haven-t-been-used-for-a-certain-.patch) at 2018-10-19 08:34:57 from Kyotaro HORIGUCHI <horiguchi.kyotaro at lab.ntt.co.jp> (Patch: Yes)
    Attachment (v5-2-PoC-0001-Remove-entries-that-haven-t-been-used-for-a-certain-.patch) at 2018-09-13 12:40:59 from Kyotaro HORIGUCHI <horiguchi.kyotaro at lab.ntt.co.jp> (Patch: Yes)
    Attachment (v5-0001-Remove-entries-that-haven-t-been-used-for-a-certain-.patch) at 2018-07-03 00:29:14 from Kyotaro HORIGUCHI <horiguchi.kyotaro at lab.ntt.co.jp> (Patch: Yes)
    Attachment (v4-0004-Generic-plan-removal-of-PlanCacheSource.patch) at 2018-06-26 09:00:03 from Kyotaro HORIGUCHI <horiguchi.kyotaro at lab.ntt.co.jp> (Patch: Yes)
    Attachment (0001-Remove-entries-that-haven-t-been-used-for-a-certain-.patch) at 2018-03-15 05:12:46 from Kyotaro HORIGUCHI <horiguchi.kyotaro at lab.ntt.co.jp> (Patch: Yes)
    Attachment (unknown_filename) at 2018-03-12 08:36:22 from Kyotaro HORIGUCHI <horiguchi.kyotaro at lab.ntt.co.jp> (Patch: No)
    Attachment (0001-Remove-entries-that-haven-t-been-used-for-a-certain-.patch) at 2018-03-12 08:34:08 from Kyotaro HORIGUCHI <horiguchi.kyotaro at lab.ntt.co.jp> (Patch: Yes)
    Attachment (v3-0001-Remove-entries-that-haven-t-been-used-for-a-certain-.patch) at 2018-03-07 08:25:45 from Kyotaro HORIGUCHI <horiguchi.kyotaro at lab.ntt.co.jp> (Patch: Yes)
    Attachment (v2-0001-Remove-entries-that-haven-t-been-used-for-a-certain-.patch) at 2018-03-07 07:19:23 from Kyotaro HORIGUCHI <horiguchi.kyotaro at lab.ntt.co.jp> (Patch: Yes)
    Attachment (Remove_old_syscache_entries_patch_v1.patch) at 2017-12-26 09:19:16 from Kyotaro HORIGUCHI <horiguchi.kyotaro at lab.ntt.co.jp> (Patch: Yes)
    Attachment (0001-Cleanup-negative-cache-of-pg_statistic-when-dropping.patch) at 2017-10-31 09:46:22 from Kyotaro HORIGUCHI <horiguchi.kyotaro at lab.ntt.co.jp> (Patch: Yes)
    Attachment (0001-Cleanup-negative-cache-of-pg_statistic-when-dropping.patch) at 2017-09-05 11:15:47 from Kyotaro HORIGUCHI <horiguchi.kyotaro at lab.ntt.co.jp> (Patch: Yes)
    Attachment (0001-Cleanup-negative-cache-of-pg_statistic-when-dropping.patch) at 2017-08-28 09:24:07 from Kyotaro HORIGUCHI <horiguchi.kyotaro at lab.ntt.co.jp> (Patch: Yes)
    Attachment (0001-Cleanup-negative-cache-of-pg_statistic-when-dropping.patch) at 2017-01-24 07:58:52 from Kyotaro HORIGUCHI <horiguchi.kyotaro at lab.ntt.co.jp> (Patch: Yes)
    Attachment (negative.patch) at 2017-01-22 22:51:53 from Jim Nasby <Jim.Nasby at BlueTreble.com> (Patch: Yes)
    Attachment (0001-Cleanup-negative-cache-of-pg_statistic-when-dropping.patch) at 2016-12-26 08:31:47 from Kyotaro HORIGUCHI <horiguchi.kyotaro at lab.ntt.co.jp> (Patch: Yes)
    Attachment (0001-Cleanup-negative-cache-of-pg_statistic-when-dropping.patch) at 2016-12-19 11:15:05 from Kyotaro HORIGUCHI <horiguchi.kyotaro at lab.ntt.co.jp> (Patch: Yes)
History
When Who What
2021-10-05 16:21:07 Jaime Casanova (jcasanov) Closed in commitfest 2021-09 with status: Returned with feedback
2021-08-03 02:26:41 Masahiko Sawada (masahikosawada) Closed in commitfest 2021-07 with status: Moved to next CF
2021-04-08 15:41:07 David Steele (dsteele) Closed in commitfest 2021-03 with status: Moved to next CF
2021-02-01 12:29:20 Masahiko Sawada (masahikosawada) Closed in commitfest 2021-01 with status: Moved to next CF
2021-01-26 09:44:53 Heikki Linnakangas (heikki) Added heikki as reviewer
2020-12-01 14:34:01 Anastasia Lubennikova (lubennikovaav) Closed in commitfest 2020-11 with status: Moved to next CF
2020-12-01 14:33:56 Anastasia Lubennikova (lubennikovaav) New status: Needs review
2020-10-01 04:35:59 Michael Paquier (michael-kun) New status: Waiting on Author
2020-10-01 04:35:54 Michael Paquier (michael-kun) Closed in commitfest 2020-09 with status: Moved to next CF
2020-08-02 21:04:26 Daniel Gustafsson (d_gustafsson) Closed in commitfest 2020-07 with status: Moved to next CF
2020-04-08 16:07:03 David Steele (dsteele) Changed targetversion to None
2020-04-08 15:25:46 David Steele (dsteele) Closed in commitfest 2020-03 with status: Moved to next CF
2020-02-01 12:50:02 Tomas Vondra (fuzzycz) Closed in commitfest 2020-01 with status: Moved to next CF
2020-01-22 05:54:03 Kyotaro Horiguchi (horiguti) New status: Needs review
2019-12-01 03:40:13 Michael Paquier (michael-kun) New status: Waiting on Author
2019-12-01 03:40:08 Michael Paquier (michael-kun) Closed in commitfest 2019-11 with status: Moved to next CF
2019-09-30 18:55:25 Álvaro Herrera (alvherre) Closed in commitfest 2019-09 with status: Moved to next CF
2019-08-01 23:52:41 Thomas Munro (macdice) Closed in commitfest 2019-07 with status: Moved to next CF
2019-04-06 20:37:30 David Steele (dsteele) Closed in commitfest 2019-03 with status: Moved to next CF
2019-02-22 00:25:17 Kyotaro Horiguchi (horiguti) New status: Needs review
2019-02-07 04:30:20 Andres Freund (andresfreund) Changed targetversion to 13
2019-02-04 05:12:49 Takayuki Tsunakawa (maumau) Added maumau as reviewer
2019-02-04 04:01:54 Michael Paquier (michael-kun) New status: Waiting on Author
2019-02-04 04:01:50 Michael Paquier (michael-kun) Closed in commitfest 2019-01 with status: Moved to next CF
2019-02-04 04:01:43 Michael Paquier (michael-kun) New status: Needs review
2018-12-01 12:58:34 Dmitry Dolgov (erthalion) New status: Waiting on Author
2018-12-01 12:58:29 Dmitry Dolgov (erthalion) Closed in commitfest 2018-11 with status: Moved to next CF
2018-11-27 06:49:51 Takeshi Ideriha (ideriha) Added ideriha as reviewer
2018-10-01 06:31:11 Michael Paquier (michael-kun) Closed in commitfest 2018-09 with status: Moved to next CF
2018-08-10 22:15:15 Andrew Dunstan (adunstan) Closed in commitfest 2018-07 with status: Moved to next CF
2018-03-30 02:27:38 Kyotaro Horiguchi (horiguti) Closed in commitfest 2018-03 with status: Moved to next CF
2018-03-21 19:28:16 David Steele (dsteele) New status: Needs review
2018-03-01 18:54:58 Andres Freund (andresfreund) New status: Waiting on Author
2018-01-31 07:16:03 Kyotaro Horiguchi (horiguti) Closed in commitfest 2018-01 with status: Moved to next CF
2018-01-31 07:15:57 Kyotaro Horiguchi (horiguti) New status: Needs review
2017-11-30 03:34:32 Michael Paquier (michael-kun) Closed in commitfest 2018-01 with status: Returned with feedback
2017-11-30 01:25:07 Michael Paquier (michael-kun) Closed in commitfest 2017-11 with status: Moved to next CF
2017-10-02 12:06:36 Daniel Gustafsson (d_gustafsson) Closed in commitfest 2017-09 with status: Moved to next CF
2017-08-28 09:38:18 Kyotaro Horiguchi (horiguti) Changed topic to Performance
2017-08-28 09:25:05 Kyotaro Horiguchi (horiguti) New status: Needs review
2017-08-14 21:33:59 Peter Eisentraut (petere) New status: Waiting on Author
2017-03-08 03:23:39 David Steele (dsteele) Closed in commitfest 2017-03 with status: Moved to next CF
2017-02-01 04:09:58 Michael Paquier (michael-kun) Closed in commitfest 2017-01 with status: Moved to next CF
2017-01-23 22:55:06 Jim Nasby (decibel) Added decibel as reviewer
2016-12-26 08:46:51 Kyotaro Horiguchi (horiguti) Changed wikilink to https://wiki.postgresql.org/wiki/Todo#Cache_Usage
2016-12-26 08:45:25 Kyotaro Horiguchi (horiguti) Changed authors to Kyotaro Horiguchi (horiguti)
2016-12-26 08:44:40 Kyotaro Horiguchi (horiguti) Attached mail thread 20161219.201505.11562604.horiguchi.kyotaro@lab.ntt.co.jp
2016-12-26 08:44:40 Kyotaro Horiguchi (horiguti) Created patch record
Edit
Comment/Review
Change Status