Skip site navigation (1) Skip section navigation (2)

Re: Re: Future plans for raw devices ?

From: Karel Zak <zakkr(at)zf(dot)jcu(dot)cz>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: norbert(dot)meissner(at)str(dot)daimler-benz(dot)com, Ohgaki Yasuo <yasuo_ohgaki(at)hotmail(dot)com>, pgsql-admin(at)postgresql(dot)org
Subject: Re: Re: Future plans for raw devices ?
Date: 2000-06-02 16:42:20
Message-ID: Pine.LNX.3.96.1000602182938.30257C-100000@ara.zf.jcu.cz (view raw or flat)
Thread:
Lists: pgsql-admin
On Fri, 2 Jun 2000, Bruce Momjian wrote:

> > > Most think that raw devices are a pain and offer little performance
> > > improvement and lots of portability and coding problems.
> > 
> >  I don't know how much it is a performance improvement (someone say 10-20%), 
> > but Bruce is probably right, it is a huge work and with dependence on 
> > hardware & system implementation. 
> > 
> >  We already discussed about it --- it is hacker's archive. 
> 
> One intresting issue is that commerical databases that recommended raw
> spaces are moving away from them, which helps us to know that the
> raw device benefit must be pretty small.

 Yes. Before one year I thought that I/O raw is very good feature. Hmm, but 
if I a little explore something about it, I in current time not sure.

 Primaty must be good operating system. A raw is a jink only :-)  

> >  IMHO now is not in PG background for features like I/O raw or on-line
> > replication. It needs better storage layout and tablespace feature.
> 
> Vadim is working on storage layout for 7.2, and replication should be
> done after WAL is implemented.

 I know. Will possible create on-line replication via WAL? Probably not,
because it needs locking over more backend. Has this feature (on-line
replication) anywise SQL engine? Sybase?

						Karel


In response to

pgsql-admin by date

Next:From: Max PyziurDate: 2000-06-02 16:53:57
Subject: Re: Re: Future plans for raw devices ?
Previous:From: Bruce MomjianDate: 2000-06-02 16:12:24
Subject: Re: Re: Future plans for raw devices ?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group