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 19CB49DC816 for ; Fri, 6 Jan 2006 05:55:45 -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 69536-09 for ; Fri, 6 Jan 2006 05:55:46 -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 B79939DC803 for ; Fri, 6 Jan 2006 05:55:42 -0400 (AST) Received: from localhost (localhost [127.0.0.1]) by ar-sd.net (Postfix) with ESMTP id AF341363ED; Fri, 6 Jan 2006 11:55:44 +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 17873-08; Fri, 6 Jan 2006 11:55:41 +0200 (EET) Received: from forge (unknown [192.168.0.11]) by ar-sd.net (Postfix) with SMTP id C029F27EBF; Fri, 6 Jan 2006 11:55:41 +0200 (EET) Message-ID: <00b201c612a7$5bca49a0$0b00a8c0@forge> From: "Andy" To: "Michael Glaesemann" Cc: References: <001d01c6120b$0d783600$0b00a8c0@forge> <20060105132006.19c7cd31.frank@wiles.org> <007f01c612a2$94b1a5b0$0b00a8c0@forge> <10D92D77-0DC5-4772-98CD-A6799E3A39C8@myrealbox.com> Subject: Re: Improving Inner Join Performance Date: Fri, 6 Jan 2006 11:54:46 +0200 MIME-Version: 1.0 Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=response Content-Transfer-Encoding: 7bit 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.120] X-Spam-Score: 0.12 X-Spam-Level: X-Archive-Number: 200601/34 X-Sequence-Number: 16512 Sorry, I had to be more specific. VACUUM ANALYZE is performed every hour. Regards, Andy. ----- Original Message ----- From: "Michael Glaesemann" To: "Andy" Cc: Sent: Friday, January 06, 2006 11:45 AM Subject: Re: [PERFORM] Improving Inner Join Performance > > On Jan 6, 2006, at 18:21 , 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. > > Just to chime in, VACUUM != VACUUM ANALYZE. ANALYZE is what updates > database statistics and affects query planning. VACUUM alone does not > do this. > >>> Do you have an index on report.id_order ? Try creating an index for >>> it if not and run a vacuum analyze on the table to see if it gets >>> rid of the sequence scan in the plan. > > Michael Glaesemann > grzm myrealbox com > > > > > ---------------------------(end of broadcast)--------------------------- > TIP 5: don't forget to increase your free space map settings > >