| From: | Dave Cramer <pg(at)fastcrypt(dot)com> |
|---|---|
| To: | Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> |
| Cc: | "Mark Kirkwood" <markir(at)paradise(dot)net(dot)nz>, "Adonias Malosso" <malosso(at)gmail(dot)com>, "Claus Guttesen" <kometen(at)gmail(dot)com>, pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: 4s query want to run faster |
| Date: | 2008-02-21 23:40:02 |
| Message-ID: | CF5DC7E9-5C88-4725-803E-4089568A40E9@fastcrypt.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)paradise(dot)net(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Scott Marlowe | 2008-02-22 00:24:54 | config settings, was: 4s query want to run faster |
| Previous Message | Scott Marlowe | 2008-02-21 23:16:10 | Re: 4s query want to run faster |