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

On Sat, Aug 05, 2006 at 08:42:23AM -0400, mark(at)mark(dot)mielke(dot)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(at)pervasive(dot)com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461