Re: [pgsql-advocacy] [HACKERS] What can we learn from MySQL?

2004-05-03 Thread Alexey Borzov
Hi! Tim Conrad wrote: I was researching an article I wrote about a comparison between Postgres and MySQL recently (If you want, you can read the article at http://www.devx.com/dbzone/Article/20743/). I noticed some clear differences between the mysql.com website and the Postgres website. Sorry,

Re: [pgsql-advocacy] [HACKERS] What can we learn from MySQL?

2004-05-03 Thread Alexey Borzov
Hi! Tim Conrad wrote: My favourite part of it is: MySQL uses traditional row-level locking. PostgreSQL uses something called Multi Version Concurrency Control (MVCC) by default. MVCC is a little different from row-level locking in that transactions on the database are performed on a