Re: [HACKERS] New PostgreSQL Tool available :pg_autotune

Tatsuo Ishii wrote:
>
> > You should have chosen a better foundation. pg_bench is notorious for
> > producing results that are (a) nonrepeatable and (b) not relevant to
> > a wide variety of situations. All it really tells you about is the
> > efficiency of a large number of updates to a small number of rows.
>
> You might want to try -N option of pgbench. It avoids updates to
> branches and tellers tables.

Cool. Do you feel this will noticeable increase the consistency of the
measurements?

The inconsistency of the internal benchmark results means that
pg_autotune has been using 5-run averages, and using a large tolerance
factor by default. It would be good to improving on that.

:-)

Regards and best wishes,

Justin Clift

> --
> Tatsuo Ishii

--
"My grandfather once told me that there are two kinds of people: those
who work and those who take the credit. He told me to try to be in the
first group; there was less competition there."
- Indira Gandhi