Mark Wong <markw@osdl.org> writes:
> I never vacuum during the test. Is it possible that all the updates
> and inserts would affect this?
That's bad; first because it possibly *is* hurting performance, and
second because if it isn't, your results could legitimately be attacked
as not representing the long-term-sustainable performance of Postgres.
VACUUM is real, unavoidable overhead and so we have to account for it
honestly.
regards, tom lane