An in-memory cache *should* be faster, and such tools absolutely have a place. A tool such as Redis can make an unusable system great, under the right conditions. It would be cool if Postgres added in-memory tables in V13 or V14.
In this case, unless the work is compounded in a loop, even the slowest times are *imperceptible* to a human being:
https://www.nngroup.com/articles/response-times-3-important-limits/
Put another way, some of your results are "20x faster" to a computer and imperceptibly different to a person.
Comment
The numbers add up and it's nice to eliminate slow things that add up when the application actually does a little bit more that just that one call.
Parent comment
An in-memory cache *should* be faster, and such tools absolutely have a place. A tool such as Redis can make an unusable system great, under the right conditions. It would be cool if Postgres added in-memory tables in V13 or V14. In this case, unless the work is compounded in a loop, even the slowest times are *imperceptible* to a human being: https://www.nngroup.com/articles/response-times-3-important-limits/ Put another way, some of your results are "20x faster" to a computer and imperceptibly different to a person.