X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 49D28D1B50E for ; Sat, 15 Nov 2003 13:14:07 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 12835-08 for ; Sat, 15 Nov 2003 09:13:38 -0400 (AST) Received: from web80208.mail.yahoo.com (web80208.mail.yahoo.com [66.218.79.43]) by svr1.postgresql.org (Postfix) with SMTP id 36692D1B51A for ; Sat, 15 Nov 2003 09:13:35 -0400 (AST) Message-ID: <20031115131338.90329.qmail@web80208.mail.yahoo.com> Received: from [65.69.56.225] by web80208.mail.yahoo.com via HTTP; Sat, 15 Nov 2003 05:13:38 PST Date: Sat, 15 Nov 2003 05:13:38 -0800 (PST) From: George Essig Subject: Re: INSERT extremely slow with large data sets (fwd) To: Slavisa Garic Cc: Slavisa Garic , pgsql-performance@postgresql.org In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200311/129 X-Sequence-Number: 4689 --- Slavisa Garic wrote: > Does VACUUM ANALYZE help with the analysis or it also speeds up the > process. I know i could try that before I ask but experiment is running > now and I am too curious to wait :), > > Anyway thanks for the hint, > Slavisa > VACUUM ANALYZE will reclaim disk space and update statistics used by the optimizer to help execute queries faster. This could speed up your inserts. See http://www.postgresql.org/docs/7.3/static/sql-vacuum.html. George Essig