On 11/9/05, Nicolay A Vasiliev <nvasiliev@whiteriversoft.com> wrote: Hello there!
I'd like to ask the PostgreSQL community for the conseptual thing. We
develop our web sites using MySQL. We like this for its high speed and
fulltext search feature. But nowadays our projects are growing fast and
we afraid our MySQL won't be able to perform large amount of complex
complicated queries. So we get a question about altenative SQL server.
In fact there are not too much from open source SQL servers, I think
only 2 serious: PostgreSQL and MaxDB. May I sak you about words for
advocacy or accusation for each of these database servers?
Run as fast as you can away from MaxDB. I've looked at the source in detail, and my money is that mysql ab will never really do anything with it. It's just a huge mess. The documentation is probably the worst I have ever seen, the command line utilities have so many options and are so poorly documented that it takes forever to figure out how to do the most basic stuff. Exporting and importing data is also a pain. I really can't say enough bad things about MaxDB. Maybe it was good a few years ago, but right now it's a huge step backwards from most anything else you could use, including mysql.
Chris