Re: Read only transactions - Commit or Rollback - Mailing list pgsql-performance

From Greg Stark
Subject Re: Read only transactions - Commit or Rollback
Date
Msg-id 87irtjah9m.fsf@stark.xeocode.com
Whole thread Raw
In response to Re: Read only transactions - Commit or Rollback  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Read only transactions - Commit or Rollback  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: Read only transactions - Commit or Rollback
Next
From: Markus Schaber
Date:
Subject: Re: Read only transactions - Commit or Rollback