[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