Re: Suggestion for optimization

"Dann Corbit" <DCorbit@connx.com> writes:

> If this is true (even after a commit) then MVCC is a very bad thing.  No
> transactions occur, and two people ask the same question yet get
> different answers.  Doesn't that scare anyone?  That would mean (among
> other things) that Postgresql cannot be used for a data warehouse.

Have you read the doc chapter about MVCC?  Sounds like you don't
quite understand how it works yet.

-Doug
-- 
Doug McNaught       Wireboard Industries      http://www.wireboard.com/
     Custom software development, systems and network consulting.     Java PostgreSQL Enhydra Python Zope Perl Apache
LinuxBSD...