Re: [PERFORM] my boss want to migrate to ORACLE

2004-08-02 Thread James Thornton
t RAID 10, not RAID 0. -- James Thornton __ Internet Business Consultant, http://jamesthornton.com ---(end of broadcast)--- TIP 8: explain analyze is your friend

Re: [ADMIN] [PERFORM] Quad processor options - summary

2004-05-13 Thread James Thornton
stripe width will work well for the log files. In this case, the write operation will be buffered in cache and the next log writes can be issued before the previous write is destaged to disk." -- James Thornton __

Re: [PERFORM] Quad processor options - summary

2004-05-13 Thread James Thornton
e's no need to deallocate any blocks, and the underlying filesystem metadata doesn't even get touched." For further study, I have compiled a list of Linux filesystem resources at: http://jamesthornton.com/hotlist/linux-filesystems/. -- James Thornton ___

Re: [PERFORM] Quad processor options - summary

2004-05-13 Thread James Thornton
nto this before? -- James Thornton __ Internet Business Consultant, http://jamesthornton.com ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your j

[PERFORM] Adapting Oracle S.A.M.E. Methodology for Postgres

2004-05-04 Thread James Thornton
0_same.pdf). Has anyone delved into this before? -- James Thornton __ Internet Business Consultant, http://jamesthornton.com ---(end of broadcast)--- TIP 2: you can get off all lists at onc

Re: [PERFORM] Recommended File System Configuration

2004-05-04 Thread James Thornton
tails on how to properly conduct a filesystem benchmark and addresses scaling and load more so than Dr. Scalzo's tests. For further study, I have compiled a list of Linux filesystem resources at: http://jamesthornton.com/hotlist/linux-filesystems/. -- James Thornton __

Re: [PERFORM] linux distro for better pg performance

2004-05-03 Thread James Thornton
per goes over the details on how to properly conduct a filesystem benchmark and addresses scaling and load more so than Dr. Scalzo's tests. For further study, I have compiled a list of Linux filesystem resources at: http://jamesthornton.com/hotlist/linux-filesystems/. -- James Thornton __

[PERFORM] Recommended File System Configuration

2004-05-02 Thread James Thornton
slow, but this was improved with XFS 1.1. I think a journaling a FS is needed for PG data since large DBs could take hours to recover on a non-journaling FS, but what about WAL files? -- James Thornton __ Internet Business Consultant, http