From: | "Andy" <frum(at)ar-sd(dot)net> |
---|---|
To: | "Frank Wiles" <frank(at)wiles(dot)org> |
Cc: | <pgsql-performance(at)postgresql(dot)org> |
Subject: | Re: Improving Inner Join Performance |
Date: | 2006-01-09 07:56:52 |
Message-ID: | 009301c614f2$41d55920$0b00a8c0@forge |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
shared_buffers = 10240
effective_cache_size = 64000
RAM on server: 1Gb.
Andy.
----- Original Message -----
From: "Frank Wiles" <frank(at)wiles(dot)org>
To: "Andy" <frum(at)ar-sd(dot)net>
Sent: Friday, January 06, 2006 7:12 PM
Subject: Re: [PERFORM] Improving Inner Join Performance
> On Fri, 6 Jan 2006 09:59:30 +0200
> "Andy" <frum(at)ar-sd(dot)net> 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(at)wiles(dot)org>
> http://www.wiles.org
> ---------------------------------
>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | TNO | 2006-01-09 10:58:19 | [PERFORMANCE] Beetwen text and varchar field |
Previous Message | Ron | 2006-01-08 21:35:11 | Re: help tuning queries on large database |