X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 205689DCB9B for ; Mon, 9 Jan 2006 03:56:56 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 07077-01 for ; Mon, 9 Jan 2006 03:56:55 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from ar-sd.net (unknown [81.196.35.136]) by postgresql.org (Postfix) with ESMTP id BA0949DC9DA for ; Mon, 9 Jan 2006 03:56:52 -0400 (AST) Received: from localhost (localhost [127.0.0.1]) by ar-sd.net (Postfix) with ESMTP id 510EE22F6D; Mon, 9 Jan 2006 09:56:53 +0200 (EET) Received: from ar-sd.net ([127.0.0.1]) by localhost (linz [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 00325-09; Mon, 9 Jan 2006 09:56:51 +0200 (EET) Received: from forge (unknown [192.168.0.11]) by ar-sd.net (Postfix) with SMTP id 9F5E521289; Mon, 9 Jan 2006 09:56:51 +0200 (EET) Message-ID: <009301c614f2$41d55920$0b00a8c0@forge> From: "Andy" To: "Frank Wiles" Cc: References: <001d01c6120b$0d783600$0b00a8c0@forge><20060105132006.19c7cd31.frank@wiles.org><001601c61297$20da58e0$0b00a8c0@forge> <20060106111231.28cdcb72.frank@wiles.org> Subject: Re: Improving Inner Join Performance Date: Mon, 9 Jan 2006 09:56:52 +0200 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0090_01C61503.04235F30" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2900.2180 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 X-Virus-Scanned: by amavisd-new at ar-sd.net X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.12 required=5 tests=[AWL=0.119, HTML_MESSAGE=0.001] X-Spam-Score: 0.12 X-Spam-Level: X-Archive-Number: 200601/52 X-Sequence-Number: 16530 This is a multi-part message in MIME format. ------=_NextPart_000_0090_01C61503.04235F30 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable shared_buffers =3D 10240 effective_cache_size =3D 64000 RAM on server: 1Gb.=20 Andy. ----- Original Message -----=20 From: "Frank Wiles" To: "Andy" 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" wrote: >=20 >> Yes I have indexes an all join fields.=20 >> The tables have around 30 columns each and around 100k rows.=20 >> The database is vacuumed every hour. =20 >=20 > What are you settings for:=20 >=20 > shared_buffers=20 > effective_cache_size >=20 > And how much RAM do you have in the server?=20 >=20 > --------------------------------- > Frank Wiles > http://www.wiles.org > --------------------------------- >=20 >=20 > ------=_NextPart_000_0090_01C61503.04235F30 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

shared_buffers =3D = 10240
effective_cache_size =3D=20 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=20 Performance

> On Fri, 6 Jan 2006 09:59:30 +0200
> "Andy" = <frum@ar-sd.net> = wrote:
>=20
>> Yes I have indexes an all join fields.
>> The = tables have=20 around 30 columns each and around 100k rows.
>> The database = is=20 vacuumed every hour.
>
> What are you settings = for:=20
>
> shared_buffers
> =20 effective_cache_size
>
> And how much RAM do you have = in the=20 server?
>=20
> ---------------------------------
> = Frank Wiles=20 <frank@wiles.org>
> http://www.wiles.org
> ---------------------------------
>
>=20
> ------=_NextPart_000_0090_01C61503.04235F30--