On 19/02/07, Ira Abramov <[EMAIL PROTECTED]> wrote:
Quoting Amos Shapira, from the post of Mon, 19 Feb: > Hello, > > Is it possible to configure PostgresQL to use raw disk partition, like > Oracle does? that was only a temporary solution for RAC untill OCFS came along and now it has become the recommended way of doing things. I see no point in mucking about with RAW devices, expecially if they are not going to be supported, as some LKML threads suggested.
"temporary"? Back in '99 Oracle wouldn't have had it any other way. When we (Sun MDE) did benchmarks of E10k for Amdocs it was all about how to shift RAID volumes and Oracle database/index/log "partitions" around to maximize performance. Anyway, now that OCFS is out and about - would it be recommended for other databases besides Oracle or is it too Oracle-specific? (side note - I'm reading linux/Documentation/vfs.txt to see how I can implement a tiny addition to procfs and had this brilliant idea for yet another db-specific filesystem but you seem to trump all over my hopes...:-). My original question stemmed from a wider perspective - I expect to have to put a business + technical case for converting from MS-SQL to PostgresQL soon. Do people with actual dirt on their hands point to a good source for Postgres performance tuning? I'm still digging postgresql.org and last time I went to a (large) book shop I saw an entire section (about 6-7 shelves) about MySQL but not a single book about PostgresQL. Cheers, --Amos
