[PERFORM] Performance of PostgreSQL and Oracle

2007-07-05 Thread lai yoke hman
Hello, I have seen some performance testing indicates that apparently the PostgreSQL 8 is faster in writing data while seems like Oracle 10g is better in reading data from database, can any one tell me why? Or is there anyone done performance benchmark on them before? This is urgent. Thanks. __

[PERFORM] Direct I/O

2007-07-05 Thread lai yoke hman
Hello, How can I know my PostgreSQL 8 is using direct I/O or buffered I/O? If using buffered I/O, how can I enable direct I/O? What is the performance difference of them? This is urgent, Thanks. _ Windows Live Spaces is here! It’s e