takacsroland

I see, thanks!

After all these comments, I am getting just happier that we will migrate. :)

Thanks, I will check out your input on table inheritance and update it.

You are right, I already corrected this. Thanks.

Oracle will also use the partitions. Regarding your other input, thanks, I will have a look.

:)

Thanks for everyone's comment, it really looks like migrating will be one of the best decisions. :)

Thanks for your inputs. Yes, you are totally right about the DDLs, you cannot mix it with DML. Seeing all the comments, it looks like a good decision to migrate. :)

In fact, my company wants to spare the expenses on Oracle. This is the main reason for migrating. We'll see how it works out. You are not the first one to point out postgre's optimizer. Is it really that bad?

Yes forinti, it is true, I agree.

Thanks, based on everyone's comment it seems it is a great decision to migrate to Postgre. Cool!