Re: Read only transactions - Commit or Rollback

Поиск
Список
Период
Сортировка
От Greg Stark
Тема Re: Read only transactions - Commit or Rollback
Дата
Msg-id 87irtjah9m.fsf@stark.xeocode.com
обсуждение исходный текст
Ответ на Re: Read only transactions - Commit or Rollback  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Read only transactions - Commit or Rollback  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-performance
Tom Lane <tgl@sss.pgh.pa.us> writes:

> That surprises me too --- can you provide details on the test case so
> other people can reproduce it?  AFAIR the only performance difference
> between SERIALIZABLE and READ COMMITTED is the frequency with which
> transaction status snapshots are taken; your report suggests you were
> spending 30% of the time in GetSnapshotData, which is a lot higher than
> I've ever seen in a profile.

Perhaps it reduced the amount of i/o concurrent vacuums were doing?

--
greg

В списке pgsql-performance по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Read only transactions - Commit or Rollback
Следующее
От: Markus Schaber
Дата:
Сообщение: Re: Read only transactions - Commit or Rollback