On Tue, 17 May 2005 22:12:17 -0700, "Jeffrey W. Baker" <[EMAIL PROTECTED]> wrote: >Incrementing random_page_cost from 4 (the default) to 5 causes the >planner to make a better decision.
We have such a low default random_page_cost primarily to mask other problems in the optimizer, two of which are . multi-column index correlation . interpolation between min_IO_Cost and max_IO_cost which approximates max_IO_cost too fast. Servus Manfred ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster