From owner-freebsd-performance@FreeBSD.ORG Fri Feb 4 15:40:52 2005 Return-Path: Delivered-To: freebsd-performance@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 51F2516A4CE for ; Fri, 4 Feb 2005 15:40:52 +0000 (GMT) Received: from web26807.mail.ukl.yahoo.com (web26807.mail.ukl.yahoo.com [217.146.176.83]) by mx1.FreeBSD.org (Postfix) with SMTP id 74B6E43D1F for ; Fri, 4 Feb 2005 15:40:51 +0000 (GMT) (envelope-from cguttesen@yahoo.dk) Received: (qmail 35526 invoked by uid 60001); 4 Feb 2005 15:40:50 -0000 Message-ID: <20050204154050.35524.qmail@web26807.mail.ukl.yahoo.com> Received: from [194.248.174.58] by web26807.mail.ukl.yahoo.com via HTTP; Fri, 04 Feb 2005 16:40:50 CET Date: Fri, 4 Feb 2005 16:40:50 +0100 (CET) From: Claus Guttesen To: freebsd-performance@freebsd.org MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Subject: an import into postgresql X-BeenThere: freebsd-performance@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: Performance/tuning List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Fri, 04 Feb 2005 15:40:52 -0000 Hi. I have a postgresql-dump at 748 MB bz2-compressed (3,8 uncompressed). I did an import on FreeBSD 5.3 and 6.0, NetBSD 2.0 and Gentoo Linux using kernel 2.6.10. The import was done on a laptop with 512 MB ram and a 3.2 GHz P4. I applied -O2 -funroll-loops -march=p4 in /etc/make.conf and did 'make world/kernel' using GENERIC as kernel on FreeBSD. Kernel on FreeBSD 6.0 and Gentoo and NetBSD was rebuild without smp. The disk was recognized as a UDMA 33 device. Postgresql was 7.4.6. The import-cmd was: time bzcat dump.bz2 | PGUSER=pgsql psql db FreeBSD 5.3 release: psql: 55 user, 36 system, 1 % CPU 1.40.17 total FreeBSD 5.3 stable: psql: 55 user, 36 system, 1 % CPU 1.39.45 total FreeBSD 6.0 current (wo. debugging and smp in kernel): psql: 55 user, 35 system, 2 % CPU 1.39.20 total NetBSD 2.0 (optimized using cpuflags in mk.conf): pgsql 49.16s user 61.99s system 2% cpu 1:30:05.82 total Gentoo (using xfs as fs): psql 136,79s user 53,57s system 1% cpu 2:45:01,57 total What puzzles me is the Gentoo-import which is almost twice as long as *BSD. When I scp'ed the file from another host the transfer-rate quickly dropped from around 7.4 MB/s to 2.5 MB/s whereas *BSD would transfer the file at approx. 7.2 MB/s. I tried the same on our Dell 2850 with a Perc-controller but only FreeBSD would install and boot where NetBSD's i386 would install but not boot. I installed Gentoo (amd64) but grub was apperantly misconfigured and panicked (stupid installer =)"(%)"(#%)&"#¤!!!) I'll try the i386-port and lilo and will post the same import-times if any one is interested. regards Claus