I am using PG on windows for development. While testing some queries I found that updates are much slower as compared to other database systems. (On avarage MySQL updates 4-5 times faster than PG in a single unique index on primary key) Why?
Another thing that I noticed is when any single column in a table is updated and having no index many (in my case 7) indexes on different columns, It takes about 180-200 secs. But when any single column in a table is updated and having many (in my
case 7) indexes on different columns, but does not have index on the column that is being updated, It takes about 800-900 secs. Why?
What can be done for such updates to make them faster?
Thanks
CPKulkarni
