Re: [PERFORM] PostgreSQL vs. Oracle disk space usage

2004-01-21 Thread Thierry Missimilly
ze. And I have not found any explanation. Regards, Thierry Missimilly Seum-Lim Gan wrote: Hi, I searched through the archive and could not find any conclusive discussion of results on this. Has anyone compared the disk space usage between PostgreSQL and Oracle ? I am interested in knowing for the s

Re: [PERFORM] tuning questions

2003-12-05 Thread Thierry Missimilly
s the max of tps. I bet, it is the disk where the WAL buffer are logged. One more thing about I/O, for an IDE disk, the maximum number of Write Block + Read Block per sec is about 1 based on the I/O block size is 1 K. That means 10 Mb/s. if you need more, you can try Stripped SCSI disks

Re: [PERFORM] very large db performance question

2003-11-27 Thread Thierry Missimilly
database, it is better to use cold backup with Snapshot tools. Regards, Thierry Missimilly LIANHE SHAO wrote: > Hello All, > We will have a very large database to store > microarray data (may exceed 80-100G some day). now > we have 1G RAM, 2G Hz Pentium 4, 1 CPU. and enough > hard di