X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 0E4A232C12A for ; Mon, 11 Oct 2004 15:22:10 +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 32319-09 for ; Mon, 11 Oct 2004 14:22:01 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id CC9B232C0E7 for ; Mon, 11 Oct 2004 15:22:04 +0100 (BST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.1/8.13.1) with ESMTP id i9BEM3YO004973; Mon, 11 Oct 2004 10:22:04 -0400 (EDT) To: Mike Harding Cc: pgsql-performance@postgresql.org Subject: Re: COPY slows down? In-reply-to: <20041008121029.EEB485486C@bsd.mvh> References: <20041008121029.EEB485486C@bsd.mvh> Comments: In-reply-to Mike Harding message dated "Fri, 08 Oct 2004 05:10:29 -0700" Date: Mon, 11 Oct 2004 10:22:03 -0400 Message-ID: <4972.1097504523@sss.pgh.pa.us> From: Tom Lane 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: 200410/136 X-Sequence-Number: 8612 Mike Harding writes: > I just ran a COPY of a million records several times, and each time I > ran it it ran apparently exponentially slower. Tell us about indexes, foreign keys involving this table, triggers, rules? Some mention of your PG version would be appropriate, too. regards, tom lane