Re: moving from MySQL to pgsql

Поиск
Список
Период
Сортировка
От Vineet Deodhar
Тема Re: moving from MySQL to pgsql
Дата
Msg-id CAP5=7oo6Hb_NKHuVvKEEAFPqzWfUq8GffaetQPz+hAAvsuHSow@mail.gmail.com
обсуждение исходный текст
Ответ на Re: moving from MySQL to pgsql  (Chris Travers <chris.travers@gmail.com>)
Ответы Re: moving from MySQL to pgsql  (Chris Travers <chris.travers@gmail.com>)
Список pgsql-general
On Wed, Oct 10, 2012 at 2:38 PM, Chris Travers <chris.travers@gmail.com> wrote:


On Wed, Oct 10, 2012 at 1:47 AM, Vineet Deodhar <vineet.deodhar@gmail.com> wrote: PostgreSQL has an excellent optimizer and the on-disk layout is completely different.  This will dwarf any changes due to threads vs queries.  
 
However be prepared to rethink your indexing strategies.

Best Wishes,
Chris Travers


Thanks Chris.
I didn't understand by what do you mean by "be prepared to rethink your indexing strategies."

In MySQL, I have created indexes, Unique indexes, complex or multi-field indexes, etc.
In what way should I re-consider the indexing?

Thanks,
Vineet

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

Предыдущее
От: Sim Zacks
Дата:
Сообщение: Re: moving from MySQL to pgsql
Следующее
От: Chris Travers
Дата:
Сообщение: Re: moving from MySQL to pgsql