Re:Understanding Postgres Performance
by madelfio on Tuesday October 02, 2012 @03:02PM
(#4603633)
I think the ratio expressions are slightly off. Using the queries from the article can result in negative ratios, which shouldn't be possible if we're measuring the percent of accesses that hit the buffer. Each access is either a cache hit or a read, not both. So instead of subtracting in the numerator, they should be added in the denominator:
[ Parent
| on HN ]
There are no comments on this comment yet.