Re: MVCC cons - Mailing list pgsql-general

From Tom Lane
Subject Re: MVCC cons
Date
Msg-id 10693.1187119847@sss.pgh.pa.us
Whole thread Raw
In response to Re: MVCC cons  (Kenneth Downs <ken@secdat.com>)
Responses Re: MVCC cons  (Kenneth Downs <ken@secdat.com>)
List pgsql-general
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

pgsql-general by date:

Previous
From: "Scott Marlowe"
Date:
Subject: Re: MVCC cons
Next
From: "Phoenix Kiula"
Date:
Subject: Compound Indexes