Why Update is too slow

Why the Update Statement works very slowly in Postgresql?

Questions by dbadba123

Showing Answers 1 - 1 of 1 Answers

postgresql

  • Jul 1st, 2010
 

Because of the MVCC architecture of PostgreSQL but is greatly improved starting PostgreSQL 8.3.x if you are not updating the index field.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions