X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 6184C3A57A2 for ; Wed, 26 Jan 2005 20:50:38 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 55961-06 for ; Wed, 26 Jan 2005 20:50:34 +0000 (GMT) Received: from wolff.to (wolff.to [66.93.249.74]) by svr1.postgresql.org (Postfix) with SMTP id 374B03A573F for ; Wed, 26 Jan 2005 20:50:34 +0000 (GMT) Received: (qmail 28954 invoked by uid 500); 26 Jan 2005 21:04:50 -0000 Date: Wed, 26 Jan 2005 15:04:50 -0600 From: Bruno Wolff III To: Dennis Sacks Cc: Joel Fradkin , pgsql-sql@postgresql.org Subject: Re: same question little different test MSSQL vrs Postgres Message-ID: <20050126210450.GA26734@wolff.to> Mail-Followup-To: Dennis Sacks , Joel Fradkin , pgsql-sql@postgresql.org References: <000901c5035a$3b619cc0$797ba8c0@jfradkin> <41F71AB4.5030208@illusions.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <41F71AB4.5030208@illusions.com> User-Agent: Mutt/1.5.6i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.007 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200501/271 X-Sequence-Number: 20059 On Tue, Jan 25, 2005 at 21:21:08 -0700, Dennis Sacks wrote: > > One of the things you'll want to do regularly is run a "vacuum analyze". > You can read up on this in the postgresql docs. This is essential to the > indexes being used properly. At a bare minimum, after you import a large > amount of data, you'll want to run vacuum analyze. Note that there is no need to vacuum after inserts (only updates and deletes), so you can just do an analyze in that case.