Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 58094476065 for ; Wed, 1 Jan 2003 16:01:14 -0500 (EST) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by postgresql.org (Postfix) with ESMTP id 9D2AF475F2B for ; Wed, 1 Jan 2003 16:01:13 -0500 (EST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.6/8.12.6) with ESMTP id h01L1Ed0008338; Wed, 1 Jan 2003 16:01:14 -0500 (EST) To: "Neil Conway" Cc: mt_pgsql@yahoo.com, pgsql-performance@postgresql.org Subject: Re: preliminary testing, two very slow situations... In-reply-to: <2973.24.112.166.30.1041375927.squirrel@mailbox.samurai.com> References: <20021231221435.26755.qmail@web14810.mail.yahoo.com> <2973.24.112.166.30.1041375927.squirrel@mailbox.samurai.com> Comments: In-reply-to "Neil Conway" message dated "Tue, 31 Dec 2002 18:05:27 -0500" Date: Wed, 01 Jan 2003 16:01:13 -0500 Message-ID: <8337.1041454873@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200301/2 X-Sequence-Number: 649 "Neil Conway" writes: > Michael Teter said: >> Now I'm trying to evaluate it as a possible >> replacement for MS SQL Server. > What version of PostgreSQL are you using? > [suggestions for tuning] The only reason I can think of for COPY to be as slow as Michael is describing is if it's checking foreign-key constraints (and even then it'd have to be using very inefficient plans for the check queries). So we should ask not only about the PG version, but also about the exact table declarations involved. regards, tom lane