Re: [rt-users] Migrating from Postgres to MySQL

2009-07-29 Thread Robert Nesius
On Tue, Jul 28, 2009 at 3:56 PM, Kenneth Marshall k...@rice.edu wrote: Kage, The main advantage is gained by avoiding I/O through the virtual disk. The layout of the virtual disk tends to turn most I/O into random I/O, even I/O that starts as sequential. The factor of 10 performance

Re: [rt-users] Migrating from Postgres to MySQL

2009-07-29 Thread Matt Simerson
On Jul 29, 2009, at 7:10 AM, Robert Nesius wrote: On Tue, Jul 28, 2009 at 3:56 PM, Kenneth Marshall k...@rice.edu wrote: Kage, The main advantage is gained by avoiding I/O through the virtual disk. The layout of the virtual disk tends to turn most I/O into random I/O, even I/O that starts

Re: [rt-users] Migrating from Postgres to MySQL

2009-07-29 Thread William Graboyes
Hi Matt, Raid is not the end-all be-all for disk safety, especially when you step into terabyte class computing, sorry I am taking this a bit off topic. While RAID has it's bonuses, there are drawbacks as well, take your standard RAID 5 setup, 4 Disks, 3 active, 1 Hot Spare. Now lets say that

Re: [rt-users] Migrating from Postgres to MySQL

2009-07-29 Thread Matt Simerson
On Jul 29, 2009, at 10:44 AM, William Graboyes wrote: Hi Matt, Raid is not the end-all be-all for disk safety, especially when you step into terabyte class computing, sorry I am taking this a bit off topic. While RAID has it's bonuses, there are drawbacks as well, take your standard

[rt-users] Migrating from Postgres to MySQL

2009-07-28 Thread Kage
Well, basically, Postgres is seemingly a bucket of fail specifically for the RT system I maintain. We run RT/Postgres on a Ubuntu Hardy LTS virtual machine running 2 virtual CPUs and the KVM maximum of 2GB RAM, but Postgres ends up using so much in resources that it actually kills the entire KVM

Re: [rt-users] Migrating from Postgres to MySQL

2009-07-28 Thread Kenneth Marshall
On Tue, Jul 28, 2009 at 03:35:12PM -0400, Kage wrote: Well, basically, Postgres is seemingly a bucket of fail specifically for the RT system I maintain. We run RT/Postgres on a Ubuntu Hardy LTS virtual machine running 2 virtual CPUs and the KVM maximum of 2GB RAM, but Postgres ends up using

Re: [rt-users] Migrating from Postgres to MySQL

2009-07-28 Thread Kage
(didn't do a reply-all, sorry if you get this twice, Ken) What, if any, performance gains exist by using an NFS mountpoint for the Postgres database within a virtual machine?  In this case, I/O is not directly placed on the virtual disk (unless the actual act of I/O itself, regardless of what is

Re: [rt-users] Migrating from Postgres to MySQL

2009-07-28 Thread Kenneth Marshall
Kage, The main advantage is gained by avoiding I/O through the virtual disk. The layout of the virtual disk tends to turn most I/O into random I/O, even I/O that starts as sequential. The factor of 10 performance difference between random/sequential I/O causes the majority of the performance