[CentOS] Future of MySQL

Les Mikesell lesmikesell at gmail.com
Mon Dec 14 13:51:43 UTC 2009


Neil Aggarwal wrote:
>> Personally I'd like to see it go down so more people will start
>> supporting PostgreSQL - which is a far better database anyway
> 
> Does PostgreSQL have non-transactional tables like MySQL?
> I am not trying to start a holy war, just asking since I
> do not know.
> 

Postgresql uses MVCC (multi-verson concurrency control) so tables aren't locked 
for transactions but each operation only sees previously committed updates.
http://www.postgresql.org/docs/current/static/mvcc-intro.html

-- 
   Les Mikesell
    lesmikesell at gmail.com





More information about the CentOS mailing list