Re: [PERFORM] [ADMIN] Raw devices vs. Filesystems

2004-04-09 Thread Josh Berkus
Grega, > Well, as I said, that's why I was asking - I'm willing to give it a go > if nobody can prove me wrong. :) Why not? If you have time? > 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. Keen! Wo

Re: [PERFORM] [ADMIN] Raw devices vs. Filesystems

2004-04-07 Thread Grega Bremec
...and on Wed, Apr 07, 2004 at 09:09:16AM -0700, Josh Berkus used the keyboard: > > 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

Re: [ADMIN] Raw devices vs. Filesystems

2004-04-07 Thread Murthy Kambhampaty
On Wednesday, April 07, 2004 1:26 AM Tom Lane wrote: > > But to get back to the point of this discussion: to allow PG > to use raw devices instead of filesystems, we'd first have to do a ton of > portability work ... [The following is said in a low, tentative voice :) ] I wonder if writing th

Re: [PERFORM] [ADMIN] Raw devices vs. Filesystems

2004-04-07 Thread Steve Atkins
On Wed, Apr 07, 2004 at 09:09:16AM -0700, Josh Berkus wrote: > If your intention in this test is to show the superiority of raw devices, let > me give you a reality check: barring some major corporate backing getting > involved, we can't possibly implement our own PG-FS for database support. We

Re: [PERFORM] [ADMIN] Raw devices vs. Filesystems

2004-04-07 Thread Josh Berkus
Grega, > Furthermore, this filesystem would be a blazing one stop solution for > all replication issues PostgreSQL currently suffers from, as its main > design goal was to present "a consistent file system image across the > servers in a cluster". Does it work, though? Without Oracle admin tool

Re: [ADMIN] Raw devices vs. Filesystems

2004-04-07 Thread Grega Bremec
...and on Wed, Apr 07, 2004 at 01:26:02AM -0400, Tom Lane used the keyboard: > > After that, we get to implement our own filesystem-equivalent management > of disk space allocation, disk I/O scheduling, etc. Are we really > smarter than all those kernel hackers doing this for a living? I doubt i

Re: [ADMIN] Raw devices vs. Filesystems

2004-04-06 Thread Tom Lane
Chris Browne <[EMAIL PROTECTED]> writes: > That claim seems really rather remarkable. > It implies an entirely stunning degree of inefficiency in the > implementation of filesystems on Solaris. Solaris has a reputation for having stunning degrees of inefficiency in a number of places :-(. On the

Re: [ADMIN] Raw devices vs. Filesystems

2004-04-06 Thread Marsh Ray
> [EMAIL PROTECTED] ("Gregory S. Williamson") writes: >>No point to beating a dead horse (other than the sheer joy of the >>thing) since postgres does not have raw device support, but ... raw >>devices, at least on solaris, are about 10 times as fast as cooked >>file systems for Informix. This mig

Re: [ADMIN] Raw devices vs. Filesystems

2004-04-06 Thread scott.marlowe
gt; From: Chris Browne [mailto:[EMAIL PROTECTED] > Sent: Tuesday, April 06, 2004 1:57 PM > To: [EMAIL PROTECTED] > Subject: Re: [ADMIN] Raw devices vs. Filesystems > > > [EMAIL PROTECTED] ("Gregory S. Williamson") writes: > > No point to beating a dead horse (ot

Re: [ADMIN] Raw devices vs. Filesystems

2004-04-06 Thread Gregory S. Williamson
Remarkable, perhaps, to you. Not in the Informix world. But irrelevant to postgres, no ? -Original Message- From: Chris Browne [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 06, 2004 1:57 PM To: [EMAIL PROTECTED] Subject: Re: [ADMIN] Raw devices vs. Filesystems [EMAIL PROTECTED

Re: [ADMIN] Raw devices vs. Filesystems

2004-04-06 Thread Chris Browne
[EMAIL PROTECTED] ("Gregory S. Williamson") writes: > No point to beating a dead horse (other than the sheer joy of the > thing) since postgres does not have raw device support, but ... raw > devices, at least on solaris, are about 10 times as fast as cooked > file systems for Informix. This might

Re: [ADMIN] Raw devices vs. Filesystems

2004-04-05 Thread Gregory S. Williamson
riginal Message- From: Christopher Browne [mailto:[EMAIL PROTECTED] Sent: Mon 3/29/2004 10:28 AM To: [EMAIL PROTECTED] Cc: Subject: Re: [ADMIN] Raw devices vs. Filesystems After takin a swig o' Arrakan spice grog, [EMAIL PROTECTED] ("Jaime Casanova") belched out:

Re: [ADMIN] Raw devices vs. Filesystems

2004-04-05 Thread Christopher Browne
After takin a swig o' Arrakan spice grog, [EMAIL PROTECTED] ("Jaime Casanova") belched out: > Can you tell me (or at least guide me to a palce where i can find the > answer) what are the benefits of filesystems over raw devices? For PostgreSQL, filesystems have the merit that you can actually use

Re: [ADMIN] Raw devices vs. Filesystems

2004-03-29 Thread Terry Hampton
Hello Jaime, I think you're on the right track but have gotten some concepts possibly confused. As I remember, the original email asked if Postgres could be run in a "raw" mode. Another submitter told us that it can not. ( Did I read that

[ADMIN] Raw devices vs. Filesystems

2004-03-29 Thread Jaime Casanova
Can you tell me (or at least guide me to a palce where i can find the answer) what are the benefits of filesystems over raw devices? And what filesystem is the best for postgresql performance? _ The new MSN 8: advanced junk mail pro