shared_buffers = 10240
effective_cache_size =
64000
RAM on server: 1Gb.
Andy.
----- Original Message -----
From: "Frank Wiles" <frank@xxxxxxxxx>
To: "Andy" <frum@xxxxxxxxx>
Sent: Friday, January 06, 2006 7:12 PM
Subject: Re: [PERFORM] Improving Inner Join
Performance
> "Andy" <frum@xxxxxxxxx> wrote:
>
>> Yes I have indexes an all join fields.
>> The tables have around 30 columns each and around 100k rows.
>> The database is vacuumed every hour.
>
> What are you settings for:
>
> shared_buffers
> effective_cache_size
>
> And how much RAM do you have in the server?
>
> ---------------------------------
> Frank Wiles <frank@xxxxxxxxx>
> http://www.wiles.org
> ---------------------------------
>
>
>
