CacheEstimateDraft
From PostgreSQL wiki
Contents |
Cache Estimates
Several workloads impact the PostgreSQL buffer cache and the Operating System page cache in different ways.
Here is an attempt to track the real-life cases where the *_cost GUC are abused to make a workload perform well. Some hypothetical scenarios are also described to illustrate possible corner-case situation or common workloads.
Hypothesis
Cached data may not be re-used vs Cached data may be re-used.
Query trash cache vs Query build cache vs Query use cache
Server is not dedicated to PostgrSQL vs server is dedicated.
Real-Life issues
Add Kevin case if possible.
Corner-Cases
One query to trash them all. (but the kernel is not stupid)
Known Patterns
Day vs Night workload
Small server, small usage.
