Re: MVCC cons

Tom Lane wrote:
> Kenneth Downs <ken(at)secdat(dot)com> 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