Date: Tue, 15 Jun 1999 11:26:46 -0400 From: Rick Siple <RickSiple@mpainc.com> To: "'freebsd-database@freebsd.org'" <freebsd-database@freebsd.org> Subject: RE: PostgreSQL 6.5 Message-ID: <8FCA4DE144C8D211A4D30090273D14196F4F@BLUE>
next in thread | raw e-mail | index | archive | help
This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_000_01BEB743.7B2167D2 Content-Type: text/plain; charset="iso-8859-1" Actually, PostgreSQL 6.5 has skipped over row-level locking (apparently they only had table level locking in 6.4.2) and is using a mechanism they call Multi-version Concurrency Control (MVCC). It is supposed to be better than row-level locking in that a reader can never be blocked by a writer. In row-level locking, once a writer reads and updates a row in a transaction, any readers wanting access to that row get blocked until the writer commits his transaction. With MVCC the readers get to read the old version of the record until the writer commits. This mechanism also obviates the need to a set number of locks. I attached the messages that was posted to the pgsql-announce mailing list. It looks like they tried to post it to the freebsd-database mailing list also, but addressed it to 'freebsd-databases' plural. __________ Rick Siple ricksiple@mpainc.com -----Original Message----- From: Clark Joel A1C AMC CSS [mailto:Joel.Clark@scott.af.mil] Sent: Tuesday, June 15, 1999 10:34 AM To: 'freebsd-database@freebsd.org' Subject: PostgreSQL 6.5 I am not the official announcer or anything, but I noticed that PostgreSQL is 6.5 is out. It now supports row-level locking and other neato features. I am a big fan of this product so please head out to http://www.postgresql.org and check it out...nice redesign of the site, too! jc -- A1C Joel S. Clark Rapid Applications Developer 01010101010100110100000101000110 To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message ------_=_NextPart_000_01BEB743.7B2167D2 Content-Type: message/rfc822 Content-Description: [ANNOUNCE] PostgreSQL v6.5: Officially Released ... Message-ID: <Pine.BSF.4.05.9906150118040.49155-100000@thelab.hub.org> From: The Hermit Hacker <scrappy@hub.org> To: pgsql-announce@postgreSQL.org Cc: freebsd-databases@freebsd.org Subject: [ANNOUNCE] PostgreSQL v6.5: Officially Released ... Date: Tue, 15 Jun 1999 00:32:04 -0400 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2448.0) Content-Type: text/plain; charset="iso-8859-1" After several months of intense development, and only almost two months of testing and bug fixes, we are pleased to announce the release of PostgreSQL v6.5 ... Due to the huge number of changes and improvements made in this last development cycle, it is highly recommended that you scan through the HISTORY file, but a few of the major changes/improvements are: Multi-version concurrency control(MVCC) This removes our old table-level locking, and replaces it with a locking system that is superior to most commercial database systems. Hot backups from pg_dump New SQL features We now have CASE, INTERSECT, and EXCEPT statement support. We have new LIMIT/OFFSET, SET TRANSACTION ISOLATION LEVEL, SELECT ... FOR UPDATE, and an improved LOCK TABLE command. Ports We continue to expand our port list, this time including WinNT/ix86 and NetBSD/arm32. and SpeedUps to several key areas within the system, to improve performance...as well as improved resource utilitization enhancements. This new release of PostgreSQL is available via: http://www.postgresql.org -> Software -> Download ------_=_NextPart_000_01BEB743.7B2167D2-- To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?8FCA4DE144C8D211A4D30090273D14196F4F>