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 320849DCA22 for ; Wed, 11 Jan 2006 14:25:51 -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 35672-07 for ; Wed, 11 Jan 2006 14:25:50 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from noel.decibel.org (noel.decibel.org [67.100.216.10]) by postgresql.org (Postfix) with ESMTP id 0A1C19DCA1F for ; Wed, 11 Jan 2006 14:25:45 -0400 (AST) Received: by noel.decibel.org (Postfix, from userid 1001) id E81073984B; Wed, 11 Jan 2006 12:25:45 -0600 (CST) Date: Wed, 11 Jan 2006 12:25:45 -0600 From: "Jim C. Nasby" To: Andy Cc: Frank Wiles , pgsql-performance@postgresql.org Subject: Re: Improving Inner Join Performance Message-ID: <20060111182545.GR3902@pervasive.com> References: <20060106111231.28cdcb72.frank@wiles.org> <009301c614f2$41d55920$0b00a8c0@forge> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <009301c614f2$41d55920$0b00a8c0@forge> X-Operating-System: FreeBSD 6.0-RELEASE amd64 X-Distributed: Join the Effort! http://www.distributed.net User-Agent: Mutt/1.5.11 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.087 required=5 tests=[AWL=0.087] X-Spam-Score: 0.087 X-Spam-Level: X-Archive-Number: 200601/118 X-Sequence-Number: 16596 Did you originally post some problem queries? The settings look OK, though 1G of memory isn't very much now-a-days. On Mon, Jan 09, 2006 at 09:56:52AM +0200, Andy wrote: > shared_buffers = 10240 > effective_cache_size = 64000 > RAM on server: 1Gb. > > Andy. > > ----- Original Message ----- > > 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: > > > >> 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 > > http://www.wiles.org > > --------------------------------- > > > > > > -- Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461