Re: Interesting article, Facebook woes using MySQL

Поиск
Список
Период
Сортировка
От Martijn van Oosterhout
Тема Re: Interesting article, Facebook woes using MySQL
Дата
Msg-id 20120314073843.GA6567@svana.org
обсуждение исходный текст
Ответ на Re: Interesting article, Facebook woes using MySQL  (Stefan Keller <sfkeller@gmail.com>)
Список pgsql-general
On Tue, Mar 13, 2012 at 01:22:18AM +0100, Stefan Keller wrote:
> Hi all
>
> 2011/7/12 Chris Travers <chris.travers@gmail.com>:
> > I am not convinced that VoltDB is a magic bullet either.  I don't
>
> I have the chance to help preparing an interview with Mike
> Stonebreaker to be published at www.odbms.org
> I'd really like to know, if he is up-to-date how Postgres performs
> these days and how he thinks how VoltDB overcame the overhead he
> claims to exist in "old elephants".
> Do you all have more questions to Mike?

I'm curious what he thinks about the role of the optimiser. IME
postgresql wins for my workloads simply because PostgreSQL is smart
enough to perform the joins in the right order and use the right
indexes. MySQL seems to have some heuristics which are wrong just often
enough to be irritating.

Oh yeah, and it doesn't have CREATE INDEX CONCURRENTLY, that's *really*
annoying.

Have a nice day,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> He who writes carelessly confesses thereby at the very outset that he does
> not attach much importance to his own thoughts.
   -- Arthur Schopenhauer

Вложения

В списке pgsql-general по дате отправления:

Предыдущее
От: John R Pierce
Дата:
Сообщение: Re: Upgrade questions
Следующее
От: Alexander Reichstadt
Дата:
Сообщение: Ways to edit users and permissions for database