Re: [PATCHES] New features for pgbench

2007-02-12 Thread Tom Lane
Greg Smith [EMAIL PROTECTED] writes: Right now when you run pgbench, the results vary considerably from run to run even if you completely rebuild the database every time. I've found that a lot of that variation comes from two things: This is a real issue, but I think your proposed patch

Re: [PATCHES] New features for pgbench

2007-02-12 Thread Greg Smith
On Mon, 12 Feb 2007, Tom Lane wrote: This is a real issue, but I think your proposed patch does not fix it. I certainly wouldn't claim that my patch _fixes_ the problem in the general case; it provides one way to measure it. Currently it's not obvious to new pgbench users that the problem

Re: [PATCHES] [BUGS] wrong behavior using to_char()

2007-02-12 Thread Bruce Momjian
Tom Lane wrote: Bruce Momjian [EMAIL PROTECTED] writes: Ultimately, the result was that glibc was wrong in its locale settings, and there was a suggestion to use defaults only when using the C locale. However, I am worried there are too many locales in the field that only define some of

Re: [PATCHES] New features for pgbench

2007-02-12 Thread NikhilS
Hi, Right now when you run pgbench, the results vary considerably from run to run even if you completely rebuild the database every time. I've found that a lot of that variation comes from two things: The main purpose of pgbench runs is an apples to apples comparison of 2 source bases. One

Re: [PATCHES] New features for pgbench

2007-02-12 Thread Tom Lane
NikhilS [EMAIL PROTECTED] writes: As long as we use the same postgresql.conf, same hardware environment and exactly same parameter pgbench runs, the difference in the TPS values observed between the 2 sources should be a good enough indicator as to the viability of the new code, dont you