Re: MVCC cons

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Kenneth Downs <ken(at)secdat(dot)com>
Cc: RPK <rpk(dot)general(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: MVCC cons
Date: 2007-08-14 19:30:47
Message-ID: 10693.1187119847@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Kenneth Downs 2007-08-14 19:34:51 Re: MVCC cons
Previous Message Scott Marlowe 2007-08-14 18:59:43 Re: MVCC cons