From: | "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com> |
---|---|
To: | Curtis Faith <curtis(at)galtair(dot)com> |
Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: 500 tpsQL + WAL log implementation |
Date: | 2002-11-12 17:16:57 |
Message-ID: | Pine.LNX.4.33.0211121013480.24725-100000@css120.ihs.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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.
From | Date | Subject | |
---|---|---|---|
Next Message | Paul Ogden | 2002-11-12 17:39:13 | Inconsistent or incomplete behavior obverse in where clause |
Previous Message | scott.marlowe | 2002-11-12 17:07:42 | Re: RE : Stability problems |