Re: interesting article: Leverage your PostgreSQL V8.1 skills to learn DB2, Version

On Sat, Aug 05, 2006 at 08:42:23AM -0400, mark@mark.mielke.cc wrote:
> On Sat, Aug 05, 2006 at 10:01:30AM +0200, Pavel Stehule wrote:
> > I found maybe interesting article 
> > http://www-128.ibm.com/developerworks/db2/library/techarticle/dm-0603wasserman2/
> 
> That for the article. I had been meaning to look at DB2, and it gave me a
> quick summary.
> 
> What I get from the article, though, is that DB2 is more modularized than
> PostgreSQL, however, it has concurrency issues. Is this true? Anybody allowed
> to comment on the peformance of small-sized (~1 million rows) databases?
> 
> I'm not seeing a compelling reason to switch.

Unless it's changed recently, it uses shared read locks, so yes, there's
definately concurrency issues to think about.
-- 
Jim C. Nasby, Sr. Engineering Consultant      jnasby@pervasive.com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461