According to Josh Berkus of PostgreSQL, three quarters of our performance trouble relates to disk access. The Transaction log and the database should not be on the same physical disk drive. Aravind suggests iSCSI, because of complications in adding disk space to the physical machine. Josh suggests to putting the database on iSCSI and the transaction log on the local drives.
Aravind, is this done, or is there more to do with configuration?
Aravind, is this done or is there more to do with configuration?
Its done. We write transaction logs to local disk, and data to the remote iscsi disk.
Ok, leaving as resolved. Thanks.