I answer here so each one can help you.

Cannot understand what you mean....index is numbered? Are you talking about "autoincrement" as called in mysql? use sequences please

Best regards

Rodrigo

Poul Møller Hansen wrote:

Rodrigo Gonzalez wrote:

Poul,

2 things....first, why do you think it will have an impact on inserts?

And the second one....use InnoDb tables in MySQL, and you will have the same than with PostgreSQL, it's because of MVCC

Best regards

Rodrigo


If the index is numbered, I assume or rather guessing that the indexes must be renumbered at inserts.

I was not trying to favourite MySQL to PostgreSQL, I prefer PostgreSQL to MySQL at any time, I was just wondering why it was much faster in MySQL and how I can achieve the same result in PostgreSQL ?


Regards, Poul



---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Reply via email to