Re: [HACKERS] Changing the default configuration

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

In response to

Responses

Browse pgsql-advocacy by date

  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:

Browse pgsql-hackers by date

  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:

Browse pgsql-performance by date

  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: