Re: Future plans for raw devices ?

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: norbert(dot)meissner(at)str(dot)daimler-benz(dot)com
Cc: Ohgaki Yasuo <yasuo_ohgaki(at)hotmail(dot)com>, pgsql-admin(at)postgresql(dot)org
Subject: Re: Future plans for raw devices ?
Date: 2000-06-02 15:04:05
Message-ID: 200006021504.LAA07160@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

> > [ Charset ISO-8859-1 unsupported, converting... ]
> > > I understand OID is signed integer which go up to 2^31.
> > > Almost any case it would be sufficient. (It's sufficient for me, at least)
> > >
> > > What I really want to know is the same as original poster.
> > >
> > > > > 8. Can a database be spread over more than one disk drive?
> >
> > Yes, by creating symbolic links for the files in data/base/dbname.
> >
> > > > > 9. Can a table be spread over more than one disk drive?
> >
> > Yes, if it gets over 1GB, it is split and a new file created. Symbolic
> > links allow them to be moved.
> >
>
> Yeah ! Strong magic! BTW: are there any plans to have the database files on raw
> devices in the future?
>

Most think that raw devices are a pain and offer little performance
improvement and lots of portability and coding problems.

--
Bruce Momjian | http://www.op.net/~candle
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Bruce Momjian 2000-06-02 15:10:49 Re: Database/table limits ??????
Previous Message Bruce Momjian 2000-06-02 14:56:40 Re: [BUGS] double dumps for all objects with pg_dump