Tom Lane wrote:
Kenneth Downs <ken@secdat.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