Re: 7.2 is slow? - Mailing list pgsql-hackers

From Zeugswetter Andreas SB SD
Subject Re: 7.2 is slow?
Date
Msg-id 46C15C39FEB2C44BA555E356FBCD6FA4212873@m0114.s-mxs.net
Whole thread Raw
In response to 7.2 is slow?  (Tatsuo Ishii <t-ishii@sra.co.jp>)
Responses Re: 7.2 is slow?  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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


pgsql-hackers by date:

Previous
From: "Zeugswetter Andreas SB SD"
Date:
Subject: Re: Thoughts on the location of configuration files, how about this:
Next
From: Daniel Kalchev
Date:
Subject: Re: Thoughts on the location of configuration files, how