Path: csiph.com!x330-a1.tempe.blueboxinc.net!usenet.pasdenom.info!news.albasani.net!weretis.net!feeder1.news.weretis.net!news.solani.org!.POSTED!not-for-mail From: Mladen Gogala Newsgroups: comp.databases.postgresql Subject: Re: Is PostgreSQL good? Date: Fri, 1 Jul 2011 13:38:27 +0000 (UTC) Organization: solani.org Lines: 15 Message-ID: References: <1308640710.210659@proxy.dienste.wien.at> <1308738638.232318@proxy.dienste.wien.at> <1308911383.819034@proxy.dienste.wien.at> <1309508018.14415@proxy.dienste.wien.at> Mime-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit X-Trace: solani.org 1309527507 29837 eJwFwQEBwDAIAzBLwCjUzt+BfwlLcMpLnYVKLPYzXSGulrH0sOkDWUNMYkAIv+g1MVO9DyOqET8= (1 Jul 2011 13:38:27 GMT) X-Complaints-To: abuse@news.solani.org NNTP-Posting-Date: Fri, 1 Jul 2011 13:38:27 +0000 (UTC) User-Agent: Pan/0.133 (House of Butterflies) X-User-ID: eJwFwYEBwDAEBMCVvsFjHBL2H6F3Jvx4XWlUW9uXmOZEUexZxo2teUMFVtzTT3dP4ghQJf4DKPcRNw== Cancel-Lock: sha1:8xxcejBuzZKAb4fPrtZT/l7Lsqo= X-NNTP-Posting-Host: eJwFwYEBwDAEBMCVIniMkz72H6F3rhAwDA7z9W2EZp7sxegRulUmO1JrXM1P6cg6y+zl7OW2feTtvMIN8JXpVL8pmSj8uQcZ+Q== Xref: x330-a1.tempe.blueboxinc.net comp.databases.postgresql:177 On Fri, 01 Jul 2011 10:13:12 +0200, Laurenz Albe wrote: > No. DB2 does not create garbage, because there is only one version of > each row at any given time. To get that, a writer has to wait until a > reader is done (i.e., the reader will take a "read lock" on the row he > or she is reading). Actually, DB2 also has MVCC, since the version 9.7 which was released, if I remember correctly, in 2009. One should set the isolation level to "currently committed" and voila, there is MVCC. -- http://mgogala.byethost5.com