Skip site navigation (1) Skip section navigation (2)

Re: [HACKERS] Changing the default configuration

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)jp>, tgl(at)sss(dot)pgh(dot)pa(dot)us
Cc: justin(at)postgresql(dot)org, 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-14 04:00:35
Message-ID: 200302132000.35639.josh@agliodbs.com (view raw or flat)
Thread:
Lists: pgsql-advocacypgsql-hackerspgsql-performance
Tatsuo,

> 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...

Hey, pg_bench is a good start on a Postgres performance tester, and it's much, 
much better than what there was before you came along ... which was nothing.  
Thank you again for contributing it.

pg_bench is, however, only  a start on a performance tester, and we'd need to 
build it up before we could use it as the basis of a PG tuner.

-- 
Josh Berkus
Aglio Database Solutions
San Francisco

In response to

pgsql-performance by date

Next:From: Tom LaneDate: 2003-02-14 04:14:49
Subject: Re: [PERFORM] [HACKERS] More benchmarking of wal_buffers
Previous:From: Darryl A. J. StaflundDate: 2003-02-14 03:55:53
Subject: Re: JBoss CMP Performance Problems with PostgreSQL 7.2.3

pgsql-hackers by date

Next:From: Tom LaneDate: 2003-02-14 04:14:49
Subject: Re: [PERFORM] [HACKERS] More benchmarking of wal_buffers
Previous:From: Tom LaneDate: 2003-02-14 04:00:02
Subject: Re: location of the configuration files

pgsql-advocacy by date

Next:From: Tom LaneDate: 2003-02-14 04:14:49
Subject: Re: [PERFORM] [HACKERS] More benchmarking of wal_buffers
Previous:From: Kevin BrownDate: 2003-02-14 03:46:46
Subject: Re: [PERFORM] [HACKERS] More benchmarking of wal_buffers

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group