Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)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?
In response to
pgsql-performance by date
|Next:||From: Markus Schaber||Date: 2005-12-20 16:07:00|
|Subject: Re: Read only transactions - Commit or Rollback|
|Previous:||From: Tom Lane||Date: 2005-12-20 15:48:08|
|Subject: Re: Read only transactions - Commit or Rollback |