On 21-Feb-08, at 6:16 PM, Scott Marlowe wrote:
> On Thu, Feb 21, 2008 at 4:59 PM, Mark Kirkwood
> <markir@paradise.net.nz> 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