Re: Future plans for raw devices ? - Mailing list pgsql-admin

From Bruce Momjian
Subject Re: Future plans for raw devices ?
Date
Msg-id 200006021504.LAA07160@candle.pha.pa.us
Whole thread Raw
Responses Re: Re: Future plans for raw devices ?
List 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@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

pgsql-admin by date:

Previous
From: "Pragati Sagar"
Date:
Subject: Accessing the database
Next
From: Norbert Meissner
Date:
Subject: Future plans for raw devices ?