Thread: 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