From: | Amit Khandekar <amitdkhan(dot)pg(at)gmail(dot)com> |
---|---|
To: | David Rowley <dgrowleyml(at)gmail(dot)com> |
Cc: | Bharath Rupireddy <bharath(dot)rupireddyforpostgres(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
Subject: | Re: Result Cache node shows per-worker info even for workers not launched |
Date: | 2021-04-28 10:59:09 |
Message-ID: | CAJ3gD9fc1uofmYY9ggH3P2AA6Bsv28wQhgQw9NeER4_y6HGa1w@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Wed, 28 Apr 2021 at 16:14, David Rowley <dgrowleyml(at)gmail(dot)com> wrote:
> However, I did add 1 test that sets work_mem down to 64kB to ensure
> the eviction code does get some exercise. You'll notice that I pass
> "true" to explain_resultcache() to hide the hits and misses there. We
> can't test the exact number of hits/misses/evictions there, but we can
> at least tell apart the zero and non-zero by how I coded
> explain_resultcache() to replace with Zero or N depending on if the
> number was zero or above zero.
Thanks for the explanation. I did realize after replying to Bharat
upthread, that I was wrong in assuming that the cache misses and cache
hits are always stable for non-parallel scans.
From | Date | Subject | |
---|---|---|---|
Next Message | Amit Khandekar | 2021-04-28 11:05:16 | Re: Result Cache node shows per-worker info even for workers not launched |
Previous Message | David Rowley | 2021-04-28 10:43:44 | Re: Result Cache node shows per-worker info even for workers not launched |