From: | Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)jp> |
---|---|
To: | tgl(at)sss(dot)pgh(dot)pa(dot)us |
Cc: | justin(at)postgresql(dot)org, josh(at)agliodbs(dot)com, merlin(dot)moncure(at)rcsonline(dot)com, pgsql-hackers(at)postgresql(dot)org, pgsql-advocacy(at)postgresql(dot)org |
Subject: | Re: [HACKERS] Changing the default configuration |
Date: | 2003-02-12 01:10:00 |
Message-ID: | 20030212.101000.74752335.t-ishii@sra.co.jp |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-advocacy pgsql-hackers pgsql-performance |
> If I thought that pgbench was representative of anything, or even
> capable of reliably producing repeatable numbers, then I might subscribe
> to results derived this way. But I have little or no confidence in
> pgbench. Certainly I don't see how you'd use it to produce
> recommendations for a range of application scenarios, when it's only
> one very narrow scenario itself.
Sigh. People always complain "pgbench does not reliably producing
repeatable numbers" or something then say "that's because pgbench's
transaction has too much contention on the branches table". So I added
-N option to pgbench which makes pgbench not to do any UPDATE to
the branches table. But still people continue to complian...
There should be many factors that would produce non-repeatable
results exist, for instance kenel buffer, PostgreSQL's buffer manager,
pgbench itself etc. etc... So far it seems no one has ever made clean
explanation why non-repeatable results happen...
--
Tatsuo Ishii
From | Date | Subject | |
---|---|---|---|
Next Message | Tatsuo Ishii | 2003-02-12 01:10:08 | Re: Changing the default configuration |
Previous Message | scott.marlowe | 2003-02-12 01:02:09 | Re: [HACKERS] Changing the default configuration (was Re: |
From | Date | Subject | |
---|---|---|---|
Next Message | Tatsuo Ishii | 2003-02-12 01:10:08 | Re: Changing the default configuration |
Previous Message | scott.marlowe | 2003-02-12 01:02:09 | Re: [HACKERS] Changing the default configuration (was Re: |
From | Date | Subject | |
---|---|---|---|
Next Message | Tatsuo Ishii | 2003-02-12 01:10:08 | Re: Changing the default configuration |
Previous Message | scott.marlowe | 2003-02-12 01:02:09 | Re: [HACKERS] Changing the default configuration (was Re: |