From: Andy <frum@ar-sd.net>
To: Frank Wiles <frank@wiles.org>
Cc: pgsql-performance@postgresql.org
Subject: Re: Improving Inner Join Performance
Date: Mon, 9 Jan 2006 09:56:52 +0200
Message-ID: <009301c614f2$41d55920$0b00a8c0@forge> (raw)
References: <001d01c6120b$0d783600$0b00a8c0@forge>
<20060105132006.19c7cd31.frank@wiles.org>
<001601c61297$20da58e0$0b00a8c0@forge>
<20060106111231.28cdcb72.frank@wiles.org>
shared_buffers = 10240
effective_cache_size = 64000
RAM on server: 1Gb.
Andy.
----- Original Message -----
From: "Frank Wiles" <frank@wiles.org>
To: "Andy" <frum@ar-sd.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@ar-sd.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@wiles.org>
> http://www.wiles.org
> ---------------------------------
>
>
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: frum@ar-sd.net, frank@wiles.org
Subject: Re: Improving Inner Join Performance
In-Reply-To: <009301c614f2$41d55920$0b00a8c0@forge>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox