On Tue, May 6, 2014 at 7:18 AM, Tom Lane <t...@sss.pgh.pa.us> wrote: > Simon Riggs <si...@2ndquadrant.com> writes: > > Lets fix e_c_s at 25% of shared_buffers and remove the parameter > > completely, just as we do with so many other performance parameters. > > Apparently, you don't even understand what this parameter is for. > Setting it smaller than shared_buffers is insane. >
The e_c_s is assumed to be usable for each backend trying to run queries sensitive to it. If you have dozens of such queries running simultaneously (not something I personally witness, but also not insane) and each of these queries has its own peculiar working set, then having e_c_s smaller than s_b makes sense. I have a hard time believe that this is at all common, however. Certainly not common enough so to justify cranking the setting all the way the other direction and then removing the crank handle. Cheers, Jeff
