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 736C89DC89A for ; Mon, 13 Mar 2006 20:40:13 -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 01612-01 for ; Mon, 13 Mar 2006 20:40:15 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from zproxy.gmail.com (zproxy.gmail.com [64.233.162.202]) by postgresql.org (Postfix) with ESMTP id 8EC679DCDBE for ; Mon, 13 Mar 2006 20:40:10 -0400 (AST) Received: by zproxy.gmail.com with SMTP id 13so1477853nzn for ; Mon, 13 Mar 2006 16:40:14 -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:subject:content-type:content-transfer-encoding; b=W3Yv/M31mLiD5/EwsDc/4iiVSx7qVzHf/MXy3KAyXf3KVe7zP1MAX7sJwd73c/jvoO6VkUzMZiiiSCjvdhrZhT6JdgDzL9L8vRoqJV+mi8FnQhbETbVovaC24TaD7lhrJXozFb/Gbm1Ron1+oKObwgwt8DQxeJF9nxhyKqPUzTA= Received: by 10.36.24.18 with SMTP id 18mr881028nzx; Mon, 13 Mar 2006 16:40:10 -0800 (PST) Received: from ?10.1.1.22? ( [203.217.18.65]) by mx.gmail.com with ESMTP id 40sm618608nzf.2006.03.13.16.40.09; Mon, 13 Mar 2006 16:40:10 -0800 (PST) Message-ID: <441610EB.7070001@gmail.com> Date: Tue, 14 Mar 2006 11:40:11 +1100 From: Chris User-Agent: Mozilla Thunderbird 1.0.7 (Windows/20050923) X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-performance@postgresql.org Subject: import performance 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/173 X-Sequence-Number: 17610 Hi all, I'm trying to work out why my 8.1 system is slower than my 7.4 system for importing data. The import is a lot of "insert into" commands - it's a converted database from another system so I can't change it to copy commands. My uncommented config options: autovacuum = off bgwriter_all_maxpages = 15 bgwriter_all_percent = 10.0 bgwriter_delay = 2000 bgwriter_lru_maxpages = 10 bgwriter_lru_percent = 5.0 checkpoint_segments = 10 commit_delay = 100000 commit_siblings = 500 temp_buffers = 500 wal_buffers = 16 max_connections = 16 shared_buffers = 256 (I was playing around with the bgwriter stuff to see if it made any differences, so I could be making it worse). It's a pretty small machine - 2.6GHz with 512M RAM. My main concern is 7.4 on a smaller machine with less memory is faster to import this data. Suggestions on what I need to do would be fantastic, thanks! -- Postgresql & php tutorials http://www.designmagick.com/