Re: MVCC cons

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: MVCC cons
Дата
Msg-id 10693.1187119847@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: MVCC cons  (Kenneth Downs <ken@secdat.com>)
Ответы Re: MVCC cons
Список 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 по дате отправления:

Предыдущее
От: "Scott Marlowe"
Дата:
Сообщение: Re: MVCC cons
Следующее
От: "Phoenix Kiula"
Дата:
Сообщение: Compound Indexes