> I think you are right that the difference between 7.1 and 7.2 may have
> more to do with the change in VACUUM strategy than anything else. Could
> you retry the test after changing all the "vacuum" commands in pgbench.c
> to "vacuum full"?
Might there also be a difference in chosen query plans ?
Wasn't 7.1 more willing to choose an index over seq scan,
even though the scan would be faster in the single user case ?
Or was that change after 7.0 ?
The seq scan would be slower that the index in the case of
many concurrent accesses.
pgsql-hackers by date
|Next:||From: Daniel Kalchev||Date: 2001-12-19 10:53:54|
|Subject: Re: Thoughts on the location of configuration files, how |
|Previous:||From: Thomas Swan||Date: 2001-12-19 10:29:05|
|Subject: Re: Thoughts on the location of configuration files|