Re: 4s query want to run faster - Mailing list pgsql-performance

From Dave Cramer
Subject Re: 4s query want to run faster
Date
Msg-id CF5DC7E9-5C88-4725-803E-4089568A40E9@fastcrypt.com
Whole thread Raw
In response to Re: 4s query want to run faster  ("Scott Marlowe" <scott.marlowe@gmail.com>)
List pgsql-performance
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


pgsql-performance by date:

Previous
From: "Scott Marlowe"
Date:
Subject: Re: 4s query want to run faster
Next
From: "Scott Marlowe"
Date:
Subject: config settings, was: 4s query want to run faster