> > 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. > > 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. -- Bruce Momjian | http://www.op.net/~candle [EMAIL PROTECTED] | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026
- Re: [ADMIN] Database/table limits ?????? Bruce Momjian
- Re: [ADMIN] Database/table limits ?????? Ohgaki Yasuo
- Re: [ADMIN] Database/table limits ?????? Chris Albertson
- Re: [ADMIN] Database/table limits ?????? Bruce Momjian
- Re: [ADMIN] Database/table limits ?????... Ohgaki Yasuo
- Re: [ADMIN] Database/table limits ... Bruce Momjian
- Re: [ADMIN] Database/table lim... Ross J. Reedstrom
- [ADMIN] Future plans for raw d... Norbert Meissner
- [ADMIN] Re: Future plans for r... Bruce Momjian
- Re: [ADMIN] Re: Future plans f... Karel Zak
- Re: [ADMIN] Re: Future plans f... Bruce Momjian
- Re: [ADMIN] Re: Future plans f... Karel Zak
- Re: [ADMIN] Re: Future plans f... Max Pyziur
- Re: [ADMIN] Re: Future plans f... Bruce Momjian
- Re: [ADMIN] Re: Future plans f... pyz
- Re: [ADMIN] Re: Future plans f... Ragnar Kjørstad
- Re: [ADMIN] Database/table limits ... Chris Albertson
- Re: [ADMIN] Database/table lim... joe briggs
- Re: [ADMIN] Database/table limits ?????? Norbert Meissner
- Re: [ADMIN] Database/table limits ?????? Bruce Momjian