X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 9B942D1D086; Thu, 8 Apr 2004 01:33:13 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 57703-02; Thu, 8 Apr 2004 01:33:09 -0300 (ADT) Received: from elbereth.noviforum.si (unknown [193.189.169.66]) by svr1.postgresql.org (Postfix) with ESMTP id A0AA1D1D09B; Thu, 8 Apr 2004 01:33:09 -0300 (ADT) Received: from elbereth.noviforum.si (localhost [127.0.0.1]) by elbereth.noviforum.si (8.12.10/8.12.10) with ESMTP id i384X5Hh028646; Thu, 8 Apr 2004 06:33:05 +0200 Received: (from gregab@localhost) by elbereth.noviforum.si (8.12.10/8.12.10/Submit) id i384X4xU028645; Thu, 8 Apr 2004 06:33:04 +0200 Date: Thu, 8 Apr 2004 06:33:04 +0200 From: Grega Bremec To: Josh Berkus Cc: pgsql-admin@postgresql.org, pgsql-performance@postgresql.org Subject: Re: [PERFORM] Raw devices vs. Filesystems Message-ID: <20040408043304.GA28539@elbereth.noviforum.si> References: <71E37EF6B7DCC1499CEA0316A25683280105786A@loki.wc.globexplorer.net> <5719.1081315562@sss.pgh.pa.us> <20040407071858.GA7973@elbereth.noviforum.si> <200404070909.16123.josh@agliodbs.com> Mime-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="k1lZvvs/B4yU6o8G" Content-Disposition: inline In-Reply-To: <200404070909.16123.josh@agliodbs.com> User-Agent: Mutt/1.4.2i Organization: Noviforum, Ltd., Software & Media X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200404/135 X-Sequence-Number: 13108 --k1lZvvs/B4yU6o8G Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable ...and on Wed, Apr 07, 2004 at 09:09:16AM -0700, Josh Berkus used the keybo= ard: >=20 > Does it work, though? Without Oracle admin tools? Hello, Josh. :) Well, as I said, that's why I was asking - I'm willing to give it a go if nobody can prove me wrong. :) > > Now, if both goals can be achieved in one go, hell, I'm willing to try > > it out myself in an attempt to extract off of it, some performance > > indicators that could be compared to other database performance tests > > sent to both this and the PERFORM mailing list. >=20 > Hey, any test you wanna run is fine with us. I'm pretty sure that OCFS= =20 > belongs to Oracle, though, patent & copyright, so we couldn't actually us= e it=20 > in practice. I thought you knew - OCFS, OCFS-Tools and OCFSv2 have not only been open- source for quite a while now - they're released under the GPL. http://oss.oracle.com/projects/ocfs/ http://oss.oracle.com/projects/ocfs-tools/ http://oss.oracle.com/projects/ocfs2/ I don't know what that means to you (probably nothing good, as PostgreSQL is released under the BSD license), but it most definitely can be considered a good thing for the end user, as she can download it, compile, and set it up on her disks, without the need to pay Oracle royalties. :) > If your intention in this test is to show the superiority of raw devices,= let=20 > me give you a reality check: barring some major corporate backing getting= =20 > involved, we can't possibly implement our own PG-FS for database support.= We=20 > already have a TODO list which is far too long for our developer pool, an= d=20 > implementing a custom FS either takes a large team (OCFS) or several year= s of=20 > development (Reiser).=20=20=20 Not really - I was just thinking about something not-entirely-a-filesystem and POK!, OCFS sprang to mind. It omits many POSIX features that slow down a traditional filesystem, yet it does know the concept of inodes and most of all, it's _really_ heavy on caching. As such, it sounded quite promising to me, but trial, I think, is the best test. The question does spring up though, that Steve raised in another post - just for the record, what POSIX semantics can a postmaster live without in a filesystem? Cheers, --=20 Grega Bremec Senior Administrator Noviforum Ltd., Software & Media http://www.noviforum.si/ --k1lZvvs/B4yU6o8G Content-Type: application/pgp-signature Content-Disposition: inline -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.3 (GNU/Linux) iD8DBQFAdNYADo/EMYD4+osRAjavAKCNkuX+bSoTf909fhLr0kt3WkcL0gCgkLoK 176SeZStwQ0aPWPRmK5g0Xs= =kDde -----END PGP SIGNATURE----- --k1lZvvs/B4yU6o8G--