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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Max Pyziur | 2000-06-02 16:53:57 | Re: Re: Future plans for raw devices ? |
Previous Message | Bruce Momjian | 2000-06-02 16:12:24 | Re: Re: Future plans for raw devices ? |