On Wed, Oct 10, 2012 at 2:38 PM, Chris Travers <chris.travers@xxxxxxxxx> wrote:
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
On Wed, Oct 10, 2012 at 1:47 AM, Vineet Deodhar <vineet.deodhar@xxxxxxxxx> 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
