Re: moving from MySQL to pgsql

On Wed, Oct 10, 2012 at 2:38 PM, Chris Travers <chris(dot)travers(at)gmail(dot)com>wrote:

>
>
> On Wed, Oct 10, 2012 at 1:47 AM, Vineet Deodhar <vineet(dot)deodhar(at)gmail(dot)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