Re: [HACKERS] cache estimates, cache access cost

2011-05-19 Thread Cédric Villemain
2011/5/19 Robert Haas robertmh...@gmail.com: On Tue, May 17, 2011 at 6:11 PM, Cédric Villemain cedric.villemain.deb...@gmail.com wrote: The point is to get ratio in cache, not the distribution of the data in cache (pgfincore also allows you to see this information). I don't see how a stable

Re: [HACKERS] cache estimates, cache access cost

2011-05-19 Thread Robert Haas
On Thu, May 19, 2011 at 8:19 AM, Cédric Villemain cedric.villemain.deb...@gmail.com wrote: 2011/5/19 Robert Haas robertmh...@gmail.com: On Tue, May 17, 2011 at 6:11 PM, Cédric Villemain cedric.villemain.deb...@gmail.com wrote: The point is to get ratio in cache, not the distribution of the

Re: [HACKERS] cache estimates, cache access cost

2011-05-19 Thread Cédric Villemain
2011/5/19 Robert Haas robertmh...@gmail.com: On Thu, May 19, 2011 at 8:19 AM, Cédric Villemain cedric.villemain.deb...@gmail.com wrote: 2011/5/19 Robert Haas robertmh...@gmail.com: On Tue, May 17, 2011 at 6:11 PM, Cédric Villemain cedric.villemain.deb...@gmail.com wrote: The point is to get

Re: [HACKERS] cache estimates, cache access cost

2011-05-17 Thread Robert Haas
On Sun, May 15, 2011 at 11:52 PM, Greg Smith g...@2ndquadrant.com wrote: Cédric Villemain wrote: http://git.postgresql.org/gitweb?p=users/c2main/postgres.git;a=shortlog;h=refs/heads/analyze_cache This rebases easily to make Cedric's changes move to the end; I just pushed a version with that

Re: [HACKERS] cache estimates, cache access cost

2011-05-17 Thread Cédric Villemain
2011/5/17 Robert Haas robertmh...@gmail.com: On Sun, May 15, 2011 at 11:52 PM, Greg Smith g...@2ndquadrant.com wrote: Cédric Villemain wrote: http://git.postgresql.org/gitweb?p=users/c2main/postgres.git;a=shortlog;h=refs/heads/analyze_cache This rebases easily to make Cedric's changes move

[HACKERS] cache estimates, cache access cost

2011-05-15 Thread Cédric Villemain
Hello cache estimation and cache access cost are currently not accounted explicitly: they have a cost associated with but no constants (other than effective_cache_size but it has a very limited usage). Every IO cost is build with a derivation of the seq_page_cost, random_page_cost and the number

Re: [HACKERS] cache estimates, cache access cost

2011-05-15 Thread Greg Smith
Cédric Villemain wrote: http://git.postgresql.org/gitweb?p=users/c2main/postgres.git;a=shortlog;h=refs/heads/analyze_cache This rebases easily to make Cedric's changes move to the end; I just pushed a version with that change to