Re: [PERFORM] Determining working set size

2012-03-27 Thread Joshua Berkus
Peter, Check out pg_fincore. Still kind of risky on a production server, but does an excellent job of measuring page access on Linux. - Original Message - > Baron Swartz's recent post [1] on working set size got me to > thinking. > I'm well aware of how I can tell when my database's wor

[PERFORM] Determining working set size

2012-03-26 Thread Peter van Hardenberg
Baron Swartz's recent post [1] on working set size got me to thinking. I'm well aware of how I can tell when my database's working set exceeds available memory (cache hit rate plummets, performance collapses), but it's less clear how I could predict when this might occur. Baron's proposed method f