Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id B96199FB441 for ; Mon, 9 Oct 2006 00:06:36 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 19319-09 for ; Mon, 9 Oct 2006 03:04:39 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey- Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id A12AE9FB44E for ; Mon, 9 Oct 2006 00:01:21 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3 Received: from noel.decibel.org (noel.decibel.org [67.100.216.10]) by svr4.postgresql.org (Postfix) with ESMTP id 33BA95AF958 for ; Sun, 8 Oct 2006 20:36:31 +0000 (GMT) Received: by noel.decibel.org (Postfix, from userid 1001) id 3B43556427; Sun, 8 Oct 2006 15:36:29 -0500 (CDT) Received: (hashcash-sendmail, from uid 1001); Sun, 8 Oct 2006 15:36:27 -0500 Date: Sun, 8 Oct 2006 15:36:27 -0500 From: "Jim C. Nasby" To: Merlin Moncure Cc: Scott Marlowe , Carlo Stonebanks , pgsql-performance@postgresql.org Subject: Re: Performance Optimization for Dummies 2 - the SQL Message-ID: <20061008203627.GL72517@nasby.net> References: <1160153623.6181.13.camel@state.g2switchworks.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: X-Operating-System: FreeBSD 6.0-RELEASE-p4 amd64 X-Distributed: Join the Effort! http://www.distributed.net User-Agent: Mutt/1.5.11 X-Hashcash: 1:20:061008:mmoncure@gmail.com::cN5mZKiKKy8EONnU:0000000000000000000 0000000000000000000000002QKb X-Hashcash: 1:20:061008:smarlowe@g2switchworks.com::ptX5ZMi4y8UpmsLs:00000000000 0000000000000000000000008yia X-Hashcash: 1:20:061008:stonec.register@sympatico.ca::vpBWsM922LyYcNjP:000000000 0000000000000000000000002N5h X-Hashcash: 1:20:061008:pgsql-performance@postgresql.org::Krn///eaTJz4SpvE:00000 0000000000000000000000003rK8 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200610/151 X-Sequence-Number: 21280 On Fri, Oct 06, 2006 at 02:53:35PM -0400, Merlin Moncure wrote: > On 10/6/06, Scott Marlowe wrote: > >On Fri, 2006-10-06 at 11:44, Carlo Stonebanks wrote: > >> This didn't work right away, but DID work after running a VACUUM FULL. In > >> other words, i was still stuck with a sequential scan until after the > >> vacuum. > >> > >> I turned autovacuum off in order to help with the import, but was > >perfoming > >> an ANALYZE with every 500 rows imported. > > how did you determine that it is done every 500 rows? this is the > default autovacuum paramater. if you followed my earlier Note that that parameter doesn't mean you'll get an analyze every 500 rows. -- Jim Nasby jim@nasby.net EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)