I’ve not worked with it nearly as much as MySQL or Postgres. But seems I can now be almost as harsh about MS SQL Server as I have been about MySQL:
<http://www.pg-versus-ms.com/ <http://www.pg-versus-ms.com/>> That just leaves Oracle. I *have* worked a goodly amount with Oracle. Oracle is significantly better than SQL Server and MySQL. And I can even imagine situations where I would choose Oracle over Postgres. Were I to describe such a situation, I would begin with something like “well, I suppose if I was working for a bank…”. For everyone else, Postgres is clearly, I will even say outrageously, obviously, and dramatically, the best database available today. On related news, I’m currently working on some tests of Postgres’ special indexes for the next meeting. The GIN index has just received a dramatic improvement in Postgres 9.4 (both smaller and faster). I’m planning on presenting results giving an indication about when you might want to use GIN or GIST indexes. For those who saw my last presentation about indexes, compound GIN and GIST indexes let the database use any of the columns in the index for a search. They are rather more complex than BTree for the database to maintain, so this involves a tradeoff between insert and query time that ought to be explored in more depth. I’m planning on running some benchmarks that will give us at least a rough idea of how GIN and GIST indexes compare for insert and query time against BTree indexes. If you use Postgres, you should come hear what I find out. -- -- SD Ruby mailing list [email protected] http://groups.google.com/group/sdruby --- You received this message because you are subscribed to the Google Groups "SD Ruby" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
