Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I have been using OpenX's AdServer with mySql as a backend, and since OpenX allows one to choose between mysql and postgres, I was wondering if anyone ever used Postgres and wished to talk about their experience with it here.

Also, is there anyone who maybe tried using OpenX with both and can offer a comparison between the databases ?

I am asking this question because I was having some trouble recently with mySql because some tables crashed occasionally and proved problematic because of the overhead they generated; and as a consequence of this, Statistics where not being generated.

share|improve this question
add comment

4 Answers 4

If you choose to stick with MySQL, you should definitely consider changing your storage engine to InnoDB. MyISAM tables are too unreliable to use in a production environment, in my opinion.

In my experience PostgreSQL performs and scales up better than MySQL, but is more tricky to get up and running. But the effort you spend getting PostgreSQL up and running is a one time cost, wherease the effort to keep MySQL running smoothly is an ongoing battle.

share|improve this answer
add comment

My experience is that PostgreSQL is handling complex queries much better than MySQL so if you will be doing some advanced SQL I can recommend PostgreSQL. It is very crash safe.

We moved to PostgreSQL for performance and license reasons. When MySQL was split in one commercial and one open sourced version, 2006 I believe, we turned to PostgreSQL. As Jay states PostgreSQL needs a bit more tuning and you might find it a bit harder to get started compared to MySQL.

// John

share|improve this answer
add comment

PostgreSQL for OpenXAd Server is not as well supported as MySQL is - for example in OpenXAd 2.8.7 statistics don't work in Postgres. Stick to MySQL with OpenXAd then.

share|improve this answer
add comment

Probably the biggest advantage to MySQL is marketshare.

By that, I mean any program you download which requires a backend database will likely have MySQL support built in. You run the setup script, and you're golden. With Postgres, it may or may not have support. Many applications likely will be able to run on Postgres with very little modification, but then you have to decide whether it's worth the time.

Personally, I'm leaning towards trying more and more Postgres when I get the chance, but I won't spend days and days trying to make something work. If it doesn't work quickly, I'll just throw it on MySQL. Of course my applications are small and mainly for personal use. In a business situation, it might be worth the extra time.

share|improve this answer
    
interesting opinon, but not really related to the question :) –  warren Nov 4 '09 at 9:07
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.