Re: 500 tpsQL + WAL log implementation - Mailing list pgsql-hackers

From scott.marlowe
Subject Re: 500 tpsQL + WAL log implementation
Date
Msg-id Pine.LNX.4.33.0211121013480.24725-100000@css120.ihs.com
Whole thread Raw
In response to Re: 500 tpsQL + WAL log implementation  ("Curtis Faith" <curtis@galtair.com>)
List pgsql-hackers
Curtis, have you considered comparing raw writes versus file system writes 
on a raw multi-disk partition?

I always set up my machines to store data on a mirror set (RAID1) or RAID5 
set, and it seems your method should be tested there too.

P.s., Tom, the postgresql user would NOT need to run as root to do this, 
you can just do a 'chown postgres.postgres /dev/sda1' or 'chown 
postgres.postgres /dev/md0' to give postgresql permission to write / read 
from a raw partition.

That said, I am not sure how much we are likely to gain from this method 
either.  But if no one tries it out we'll never know.



pgsql-hackers by date:

Previous
From: "scott.marlowe"
Date:
Subject: Re: RE : Stability problems
Next
From: Tom Lane
Date:
Subject: Re: RC1?