logo       

Re: Comparison of PGSQL and DB2: msg#00060

Subject: Re: Comparison of PGSQL and DB2
On Thu, Mar 11, 2004 at 14:21:09 -0500,
  Robert Treat <xzilla@xxxxxxxxxxxxxxxxxxxxx> wrote:
> On Thu, 2004-03-11 at 13:59, Peter Eisentraut wrote:
> > Josh Berkus wrote:
> > > > Isolation Levels
> > > > (Support all four ANSI isolation levels (UR, CS, RS, RR).)
> > >
> > > I'm not sure about this one; I suspect that we do, however, since
> > > MVCC, invented for the Postgres Project, has become a standard for
> > > transaction isolation in the database industry.
> > 
> > 7.5 will support all four isolation levels.
> > 
> 
> I wasn't aware of anyone doing work on this... do you have any more
> info?

My memory of past discussion on this is that you would be able to set all
4 transaction isolation levels in a command, but you would really get
the next level up for the two that we don't provide. This is OK since
since they get at least the transaction isolation safety they need.
The reason for doing this is portability.

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings



<Prev in Thread] Current Thread [Next in Thread>
Google Custom Search

Recently Viewed:
boot-loaders.gr...    php.pear.genera...    debugging.valgr...    kde.redhat.user...    text.xml.xsl.ge...    culture.languag...    hardware.microc...    java.servicemix...    redhat.release....    web.zope.plone....    user-groups.lin...    opendarwin.webk...    video.mjpeg.use...    sysutils.bcfg2....    encryption.gpg....    lx-office.devel...    xfree86.forum/2...    mail.mutt.devel...    acpi.devel/2003...    qnx.openqnx.dev...    network.irc.irs...    freebsd.devel.m...   
Home | blog view | USPTO Patent Archive | advertise | OSDir is an inevitable website. super tiny logo

Free Magazines

Cisco News
Receive a free quarterly e-newsletter with exclusive articles on how Cisco IT uses its own products and solutions to enable the business.
subscribe

Systems Management News, the newspaper for IT systems administration and data center managers! Each issue of Systems Management News is chock-full of news and analysis to help you understand what's happening in your field.
subscribe

The Enterprise Newsweekly eWeek is the essential technology information source for builders of e-business.
subscribe

Oracle Magazine Oracle Magazine contains technology strategy articles, sample code, tips, Oracle and partner news, how to articles for developers and DBAs, and more. Oracle (NASDAQ: ORCL) is the world's largest enterprise software company.
subscribe

Total Telecom Total Telecom is "The Economist of the communications industry".
subscribe