We have a production server(8.0.2) running 24x7, 300k+ transactions per day. Linux 2.6.11 / JFS file system. No problems. It works faster than ext3.
> Alex Turner wrote: > > > I would also recommend looking at file system. For us JFS worked > > signifcantly > > faster than resier for large read loads and large write loads, so we chose > > JFS > > over ext3 and reiser. > > has jfs been reliable for you? there seems to be a lot of conjecture about > instability, > but i find jfs a potentially attractive alternative for a number of reasons. > > richard > > ---------------------------(end of broadcast)--------------------------- > TIP 9: In versions below 8.0, the planner will ignore your desire to > choose an index scan if your joining column's datatypes do not > match -- Evgeny Gridasov Software Developer I-Free, Russia ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend