Re: Advice on testing buffer spin lock contention

> You will want a select only workload in which all data fits in
> shared_buffers, and that doesn't do a round trip to some external driver
> program for each row selected.
>
> I proposed a patch for pgbench to add a new transaction of this nature last
> year under the subject "pgbench--new transaction type". Heikki also
> described how you can make a custom pgbench -f file to accomplish the same
> thing without having to change and recompile pgbench.
>
>
> There was also a length discussion about nailing certain pages so they don't
> need to get pinned and unpinned all the time, under "9.2beta1, parallel
> queries, ReleasePredicateLocks, CheckForSerializableConflictIn in the
> oprofile"
>

Thanks a ton, we will try it out.

Regards,

Atri

--
Regards,

Atri
l'apprenant