Обсуждение: Raw Device Support

  hi guys.

Does postgreSQl support raw partitions?

Majid Azimi <majid.merkava@gmail.com> writes:
> Does postgreSQl support raw partitions?

No.

            regards, tom lane

On 09/04/2010 01:59 PM, Majid Azimi wrote:
>    hi guys.
>
> Does postgreSQl support raw partitions?
>
>
In Postgres, each table is a file. That means that Postgres needs a file
system. Raw devices are not supported. Unfortunately, direct I/O is not
supported either.

--
Mladen Gogala
Sr. Oracle DBA
1500 Broadway
New York, NY 10036
(212) 329-5251
www.vmsinfo.com
The Leader in integrated Media Intelligence Solutions

Mladen Gogala wrote:
> On 09/04/2010 01:59 PM, Majid Azimi wrote:
> >    hi guys.
> >
> > Does postgreSQl support raw partitions?
> >
> >
> In Postgres, each table is a file. That means that Postgres needs a file
> system. Raw devices are not supported. Unfortunately, direct I/O is not
> supported either.

We do support direct i/o for the write-ahead logs (WAL).

--
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + It's impossible for everything to be true. +

Bruce Momjian wrote:
> Mladen Gogala wrote:
>
>>
>
> We do support direct i/o for the write-ahead logs (WAL).
>
>
Yes, you're right, I forgot about that.

--
Mladen Gogala
Sr. Oracle DBA
1500 Broadway
New York, NY 10036
(212) 329-5251
www.vmsinfo.com