Postgres Pro
Downloads
Home   >   mailing lists

Re: moving from MySQL to pgsql - Mailing list pgsql-general

From Vineet Deodhar
Subject Re: moving from MySQL to pgsql
Date
Msg-id CAP5=7oo6Hb_NKHuVvKEEAFPqzWfUq8GffaetQPz+hAAvsuHSow@mail.gmail.com
Whole thread Raw
In response to Re: moving from MySQL to pgsql  (Chris Travers <chris.travers@gmail.com>)
Responses Re: moving from MySQL to pgsql  (Chris Travers <chris.travers@gmail.com>)
List pgsql-general
Tree view
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 by date:

Previous
From: Sim Zacks
Date:
Subject: Re: moving from MySQL to pgsql
Next
From: Chris Travers
Date:
Subject: Re: moving from MySQL to pgsql