Re: 500 tpsQL + WAL log implementation

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.

In response to

Browse pgsql-hackers by date

  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