On 21-Feb-08, at 6:16 PM, Scott Marlowe wrote:
On Thu, Feb 21, 2008 at 4:59 PM, Mark Kirkwood
<markir@xxxxxxxxxxxxxxx> wrote:
The other parameter you might want to look at is
effective_cache_size -
increasing it will encourage index use. On a machine with 16GB the
default is probably too small (there are various recommendations
about
how to set this ISTR either Scott M or Greg Smith had a page
somewhere
that covered this quite well - guys?).
The default is always too small in my experience.
What are the rest of the configuration values ?
Dave
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
