X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 4E3CA9DCA09 for ; Mon, 13 Mar 2006 22:27:27 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 14081-08 for ; Mon, 13 Mar 2006 22:27:30 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from zproxy.gmail.com (zproxy.gmail.com [64.233.162.203]) by postgresql.org (Postfix) with ESMTP id 7B33A9DC829 for ; Mon, 13 Mar 2006 22:27:24 -0400 (AST) Received: by zproxy.gmail.com with SMTP id 13so1496705nzn for ; Mon, 13 Mar 2006 18:27:29 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:user-agent:x-accept-language:mime-version:to:cc:subject:references:in-reply-to:content-type:content-transfer-encoding; b=q8O/p8Ljo1PSD2VERQTBs0ScDo5USVVIIwQCnHgX4b7vGST4veoLD69fzR+5JHqN5/WbLPC06t0IYruQckhFUpBJaYuXFquyp4+nXF0W0/cM9vrJLvCsmi/cF9MzX4AqWA0kVesEyW8eKGRqL0X/AUy3MlP4ZOz+lsErQT+ZF3s= Received: by 10.37.20.37 with SMTP id x37mr252473nzi; Mon, 13 Mar 2006 18:27:29 -0800 (PST) Received: from ?10.1.1.22? ( [203.217.18.65]) by mx.gmail.com with ESMTP id 14sm290035nzp.2006.03.13.18.27.27; Mon, 13 Mar 2006 18:27:28 -0800 (PST) Message-ID: <44162A10.7080205@gmail.com> Date: Tue, 14 Mar 2006 13:27:28 +1100 From: Chris User-Agent: Mozilla Thunderbird 1.0.7 (Windows/20050923) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Tom Lane CC: Frank Wiles , pgsql-performance@postgresql.org Subject: Re: import performance References: <441610EB.7070001@gmail.com> <44161B46.5050801@gmail.com> <20060313193318.61709662.frank@wiles.org> <44161F7D.9070707@gmail.com> <12028.1142301081@sss.pgh.pa.us> In-Reply-To: <12028.1142301081@sss.pgh.pa.us> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.118 required=5 tests=[AWL=0.118] X-Spam-Score: 0.118 X-Spam-Level: X-Archive-Number: 200603/183 X-Sequence-Number: 17620 Tom Lane wrote: > Chris writes: > >>Tons of difference :/ > > > Have you checked that the I/O performance is comparable? It seems > possible that there's something badly misconfigured about the disks > on your new machine. Benchmarking with "bonnie" or some such would > be useful; also try looking at "iostat 1" output while running the > inserts on both machines. I'll check out bonnie, thanks. hdparm shows a world of difference (which I can understand) - that being the old server is a lot slower. hdparm -t /dev/hda /dev/hda: Timing buffered disk reads: 24 MB in 3.13 seconds = 7.67 MB/sec hdparm -T /dev/hda /dev/hda: Timing cached reads: 596 MB in 2.00 seconds = 298.00 MB/sec Newer server: hdparm -t /dev/hda /dev/hda: Timing buffered disk reads: 70 MB in 3.02 seconds = 23.15 MB/sec hdparm -T /dev/hda /dev/hda: Timing cached reads: 1512 MB in 2.00 seconds = 754.44 MB/sec > Also, are the inserts just trivial "insert values (... some constants ...)" > or is there more to it than that? Straight inserts, no foreign keys, triggers etc. The only other thing I can see is the old server is ext2: /dev/hda4 on / type ext2 (rw,errors=remount-ro) the new one is ext3: /dev/hda2 on / type ext3 (rw) If it's a server issue not a postgres issue I'll keep playing :) I thought my config was bad but I guess not. Thanks for all the help. -- Postgresql & php tutorials http://www.designmagick.com/