Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 274EC6501BA for ; Fri, 21 Nov 2008 16:09:06 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 67248-01 for ; Fri, 21 Nov 2008 16:09:00 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from smtp-out.neti.ee (smtp-out.neti.ee [194.126.126.44]) by mail.postgresql.org (Postfix) with ESMTP id 9FD0164FE69 for ; Fri, 21 Nov 2008 16:08:59 -0400 (AST) X-Virus-Scanned: Debian amavisd-new at estpak.ee Received: from Relayhost3.neti.ee (relayhost3.estpak.ee [88.196.174.169]) by MXR-8.estpak.ee (Postfix) with ESMTP id 64F1A150A85; Fri, 21 Nov 2008 22:08:53 +0200 (EET) X-SMTP-Auth-NETI-Businesmail: no Received: from andrusnotebook (unknown [195.50.198.194]) by Relayhost3.neti.ee (Postfix) with SMTP id 34010D4CA2; Fri, 21 Nov 2008 22:08:49 +0200 (EET) Message-ID: <049C2591982D4B2A81E45043922A9656@andrusnotebook> From: "Andrus" To: "Alvaro Herrera" Cc: "Richard Huxton" , "PFC" , References: <49253FE1.3070706@archonet.com> <0205611B528C4C2CBA99AFC64E57D6E8@andrusnotebook> <75A918DFCF25470FAF96B3FE3D25A38B@andrusnotebook> <4926E2B2.9050202@archonet.com> <8A78204AA6D44C04B053E6412B244E13@andrusnotebook> <8D7F64CF7F614E13AC554D6CF86F39B2@andrusnotebook> <20081121191646.GH5210@alvh.no-ip.org> <20081121194805.GI5210@alvh.no-ip.org> In-Reply-To: <20081121194805.GI5210@alvh.no-ip.org> Subject: Re: Hash join on int takes 8..114 seconds Date: Fri, 21 Nov 2008 22:08:45 +0200 MIME-Version: 1.0 Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=original Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Windows Mail 6.0.6001.18000 X-MimeOLE: Produced By Microsoft MimeOLE V6.0.6001.18049 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=STOX_REPLY_TYPE=0.001 X-Spam-Level: X-Archive-Number: 200811/194 X-Sequence-Number: 31925 Alvaro, > 1. vacuum_cost_delay does not affect vacuum full > 2. vacuum full is always blocking, regardless of settings So only way is to disable other database acces if vacuum full is required. > So I gather you're not doing any vacuuming, eh? Log files for every day are full of garbage messages below. So I hope that vacuum is running well, isn't it ? Andrus. 2008-11-19 00:00:48 EET 11728 1 LOG: autovacuum: processing database "postgres" 2008-11-19 00:01:48 EET 11729 1 LOG: autovacuum: processing database "mydb1" 2008-11-19 00:02:48 EET 11730 1 LOG: autovacuum: processing database "emydb1" 2008-11-19 00:03:48 EET 11731 1 LOG: autovacuum: processing database "template1" 2008-11-19 00:04:48 EET 11732 1 LOG: autovacuum: processing database "testmydb1" 2008-11-19 00:05:48 EET 11733 1 LOG: autovacuum: processing database "mydb3" 2008-11-19 00:06:48 EET 11734 1 LOG: autovacuum: processing database "postgres" 2008-11-19 00:07:48 EET 11735 1 LOG: autovacuum: processing database "mydb1" 2008-11-19 00:08:48 EET 11736 1 LOG: autovacuum: processing database "emydb1" 2008-11-19 00:09:48 EET 11737 1 LOG: autovacuum: processing database "template1" 2008-11-19 00:10:48 EET 11750 1 LOG: autovacuum: processing database "testmydb1" 2008-11-19 00:11:48 EET 11751 1 LOG: autovacuum: processing database "mydb3" 2008-11-19 00:12:48 EET 11752 1 LOG: autovacuum: processing database "postgres" 2008-11-19 00:13:48 EET 11753 1 LOG: autovacuum: processing database "mydb1" 2008-11-19 00:14:48 EET 11754 1 LOG: autovacuum: processing database "emydb1" 2008-11-19 00:15:48 EET 11755 1 LOG: autovacuum: processing database "template1" 2008-11-19 00:16:48 EET 11756 1 LOG: autovacuum: processing database "testmydb1" 2008-11-19 00:17:48 EET 11757 1 LOG: autovacuum: processing database "mydb3" ...