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?
Status: NEW → RESOLVED
Last Resolved: 10 years ago
Resolution: --- → FIXED
Its done. We write transaction logs to local disk, and data to the remote iscsi disk.
Ok, leaving as resolved. Thanks.
Component: Socorro → General
Product: Webtools → Socorro
You need to log in before you can comment on or make changes to this bug.