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!

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 the

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 it.

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 tools?

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 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 in

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-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 scott.marlowe
:[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 (other than the sheer joy of the thing) since postgres does not have raw device

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 might still

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-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-04-05 Thread Gregory S. Williamson
- 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: Can you tell me (or at least

[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

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