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 1DE79329E7C for ; Tue, 21 Sep 2004 12:31:42 +0100 (BST) 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 74348-04 for ; Tue, 21 Sep 2004 11:31:30 +0000 (GMT) Received: from p15124592.pureserver.info (p15124592.pureserver.info [217.160.181.164]) by svr1.postgresql.org (Postfix) with ESMTP id DCF00329E66 for ; Tue, 21 Sep 2004 12:31:31 +0100 (BST) Received: from localhost (localhost [127.0.0.1]) by p15124592.pureserver.info (Postfix) with ESMTP id DB05C17AD6; Tue, 21 Sep 2004 13:31:29 +0200 (CEST) Received: from kniso.homeip.net (pD954D994.dip.t-dialin.net [217.84.217.148]) by p15124592.pureserver.info (Postfix) with ESMTP id 6142F17AD5 for ; Tue, 21 Sep 2004 13:31:28 +0200 (CEST) Received: from localhost (localhost [127.0.0.1]) by kniso.homeip.net (Postfix) with ESMTP id 595E0D7995 for ; Tue, 21 Sep 2004 13:31:12 +0200 (CEST) Received: from kniso.homeip.net ([127.0.0.1]) by localhost (server.kniso.homeip.net [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 20968-05 for ; Tue, 21 Sep 2004 13:31:07 +0200 (CEST) Received: from [192.168.100.110] (nexus.kniso.homeip.net [192.168.100.110]) by kniso.homeip.net (Postfix) with ESMTP id 4233ED7994 for ; Tue, 21 Sep 2004 13:31:07 +0200 (CEST) Message-ID: <4150115E.3080307@mk-os.de> Date: Tue, 21 Sep 2004 13:32:46 +0200 From: Martin Knipper User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; de-AT; rv:1.7) Gecko/20040616 X-Accept-Language: de, en MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: Re: degradation in performance References: <41502C4F.15411.6617D37@localhost> In-Reply-To: <41502C4F.15411.6617D37@localhost> X-Enigmail-Version: 0.85.0.0 X-Enigmail-Supports: pgp-inline, pgp-mime Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new-20030616-p10 (Debian/SARGE) at kniso.homeip.net X-Virus-Scanned: by AMaViS at MK-OS X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200409/185 X-Sequence-Number: 19031 Am 21.09.2004 13:27 schrieb Alain Reymond: > > Do you have any idea how I can improve speed - apart from splitting > the table every 2 or 3 years which is the the aim of a database! > Drop the index before you insert the data and recreate it afterwards. Use the "copy from ..." command instead of "insert into". Greetings, Martin -- Martin Knipper www : http://www.mk-os.de Mail : knipper@mk-os.de