| From: | "Zeugswetter Andreas SB SD" <ZeugswetterA(at)spardat(dot)at> |
|---|---|
| To: | "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "Hannu Krosing" <hannu(at)tm(dot)ee> |
| Cc: | "Tatsuo Ishii" <t-ishii(at)sra(dot)co(dot)jp>, <pgsql-hackers(at)postgresql(dot)org>, <inxc(at)itmeedia(dot)ee> |
| Subject: | Re: 7.2 is slow? |
| Date: | 2001-12-19 10:38:28 |
| Message-ID: | 46C15C39FEB2C44BA555E356FBCD6FA4212873@m0114.s-mxs.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
> 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.
Andreas
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Daniel Kalchev | 2001-12-19 10:53:54 | Re: Thoughts on the location of configuration files, how |
| Previous Message | Thomas Swan | 2001-12-19 10:29:05 | Re: Thoughts on the location of configuration files |