Re: MVCC cons

[Kenneth Downs <ken@xxxxxxxxxx>]

Tom Lane wrote:

Kenneth Downs <ken@xxxxxxxxxx> writes:
  

Speaking as an end-user, I can give only one I've ever seen, which is 
performance.  Because of MVCC, Postgres's write performance (insert and 
update) appears on my systems to be almost exactly linear to row size.  
Inserting 1000 rows into a table with row size 100 characters takes 
twice as long as inserting 1000 rows into a table with row size 50 
characters.
    

Not sure why you'd think that's specific to MVCC.  It sounds like purely
an issue of disk write bandwidth.

			regards, tom lane
  

I did not see this in MS SQL Server.

-- 
Kenneth Downs
Secure Data Software, Inc.
www.secdat.com    www.andromeda-project.org
631-689-7200   Fax: 631-689-0527
cell: 631-379-0010