X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 2B9193A4579 for ; Thu, 25 Nov 2004 06:34:43 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 36130-01 for ; Thu, 25 Nov 2004 06:34:40 +0000 (GMT) Received: from flake.decibel.org (flake.decibel.org [66.143.173.58]) by svr1.postgresql.org (Postfix) with ESMTP id 6084B3A4533 for ; Thu, 25 Nov 2004 06:34:40 +0000 (GMT) Received: by flake.decibel.org (Postfix, from userid 1001) id DCB641C8F3; Thu, 25 Nov 2004 06:34:38 +0000 (GMT) Date: Thu, 25 Nov 2004 00:34:38 -0600 From: "Jim C. Nasby" To: Vincent Chen Cc: pgsql-admin@postgresql.org Subject: Re: hardware to get best performance Message-ID: <20041125063438.GI41545@decibel.org> References: <20041124053006.79880.qmail@web54401.mail.yahoo.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20041124053006.79880.qmail@web54401.mail.yahoo.com> X-Operating-System: FreeBSD 4.10-RELEASE-p3 i386 X-Distributed: Join the Effort! http://www.distributed.net User-Agent: Mutt/1.5.6i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200411/188 X-Sequence-Number: 15571 ext3 is just ext2 with journalling, and from what I've heard is rather slow. ext2 is fast because it's async. RFS is fast at losing your data. :) UFS is rock-solid and is still being developed. In the past couble years it's been changed to support some monsterous file and filesystem sizes and has had soft-updates added. Soft-updates order metadata and data writes in such a way that the filesystem will always come up in a consistent state. It does what journaling does without the performance drawback of a fixed journal space on the drive. Another advantage FreeBSD has is that the kernel will take process priority into account when it's scheduling disk IO. This means you can nice long-running processes and not starve other processes for disk IO. Some people think having a half-dozen filesystems to choose from is an advantage. Personally, I'd much rather stick with a filesystem that's proven itself for the past 30 years. On Wed, Nov 24, 2004 at 01:30:06PM +0800, Vincent Chen wrote: > >> Hi, all > >> > >> Does postgresql support thread? Or let me put it this way, will postgresql > get > >> better performance on multiple processor host than single processor? What's > the > >> best platform, freebsd? linux? > > > >If you have multiple connections to the database server making simultaneous > >queries, multiple processors will be used. This is the normal case for > >real database use. > > > >The best platform for you is probably the one you are most familiar with. > > > > About platform, linux has much more filesystem choice than freebsd. If I put > postgresql data file on new filesystem like xfs or reiserfs, is it possible > that overall performance will be better than old filesystem like ufs? > > > Thanks for your response, > > > Vincent Chen > > > ----------------------------------------------------------------- > Yahoo!?_???y?????F > ???s???y?????F???W???A???H???W?????H???m?I > http://tw.avatar.yahoo.com/ > > ---------------------------(end of broadcast)--------------------------- > TIP 6: Have you searched our list archives? > > http://archives.postgresql.org > -- Jim C. Nasby, Database Consultant decibel@decibel.org Give your computer some brain candy! www.distributed.net Team #1828 Windows: "Where do you want to go today?" Linux: "Where do you want to go tomorrow?" FreeBSD: "Are you guys coming, or what?"