Date: Fri, 4 Feb 2005 16:40:50 +0100 (CET) From: Claus Guttesen <cguttesen@yahoo.dk> To: freebsd-performance@freebsd.org Subject: an import into postgresql Message-ID: <20050204154050.35524.qmail@web26807.mail.ukl.yahoo.com>
next in thread | raw e-mail | index | archive | help
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
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20050204154050.35524.qmail>