"Joshua D. Drake" <jd@commandprompt.com> writes:
> Tom Lane wrote:
>> Addition of foreign key checking will certainly impact performance
>> significantly.
> That is kind of the point. Without foreign keys it is a flawed test
> because you wouldn't be running in production without them and thus you
> can't bench without them.
pgbench is not about reality, though. If we can't rely on it to give
consistent results across versions then I don't think it's useful at all.
There are many other benchmarks you can run that do speak to reality
(eg OSDL's work).
regards, tom lane