Ok, I’ve got a stupid/wonderful question for all you fellow RT users…
Which is RT best fit for? PostgreSQL or MySQL?
I’ve heard some major problems with PostgreSQL dealing with table corruption
and whatnot. What has been everyone experiences with these two databases?
Should I stick to MySQL or switch to MySQL? Thanks.
– Paul Burkett
“PB” == Paul Burkett pburkett@callatg.com writes:
PB> I’ve heard some major problems with PostgreSQL dealing with table
PB> corruption and whatnot. What has been everyone experiences with
Last table corruption I had with postgres was at version 6.5, about 4
years ago.
Last table corruption I had with MySQL was at version 3.22.xx about 4
years ago.
Current versions are stable.
Postgres has the advantage that it handles concurrency better due to
its row-level locking. I hear recent versions of MySQL offer this
with certain table types, too.
It really boils down to what you know and what you use for your other
apps anyway. That’s why I chose Postgres – I use it for my primary
application.
“PB” == Paul Burkett pburkett@callatg.com writes:
PB> I’ve heard some major problems with PostgreSQL dealing with table
PB> corruption and whatnot. What has been everyone experiences with
Last table corruption I had with postgres was at version 6.5, about 4
years ago.
Last table corruption I had with MySQL was at version 3.22.xx about 4
years ago.
Current versions are stable.
Postgres has the advantage that it handles concurrency better due to
its row-level locking. I hear recent versions of MySQL offer this
with certain table types, too.
It really boils down to what you know and what you use for your other
apps anyway. That’s why I chose Postgres – I use it for my primary
application.
Vivek Khera, Ph.D. Khera Communications, Inc.
Internet: khera@kciLink.com Rockville, MD +1-240-453-8497
AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/
Should I stick to MySQL or switch to MySQL? Thanks.
That’s a trick question, right? 
I would suggest using the db you are most comfortable with. RT was
originally written for MySQL but I hear the PostgreSQL support is pretty
good now.
Regarding corruption, we have never experienced that on our MySQL 3.22.x
installs and we still have some high profile (non-RT) services using MySQL
3.22.x as the backend. We are even still running RT1.x on MySQL 3.22.x with
35,000 tickets (RT2 is installed with MySQL 3.23.x and migration begins
soon).