pg.ddx.io  pgsql-hackers@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Fabien COELHO <coelho@cri.ensmp.fr>
To: Robert Haas <robertmhaas@gmail.com>
Cc: Josh Berkus <josh@agliodbs.com>
Cc: pgsql-hackers@postgresql.org <pgsql-hackers@postgresql.org>
Subject: Re: pgbench stats per script & other stuff
Date: Thu, 23 Jul 2015 18:15:24 +0200 (CEST)
Message-ID: <alpine.DEB.2.10.1507231759400.10585@sto> (raw)
In-Reply-To: <CA+TgmobZSBmWzugAQp94=q98c2fmSBc+gRPwfNM+94dhjpL3tg@mail.gmail.com>
References: <alpine.DEB.2.10.1507171544450.26125@sto>
	<CA+Tgmoa=ud6E=4afK3srNj_4j8Cckm4OD_=0=uxSD5JVwsO4rQ@mail.gmail.com>
	<alpine.DEB.2.10.1507211626000.30948@sto>
	<CA+TgmoYQi7sPG+b_19Y4bn2wUPUujsSZ_qOF8nWZTrC1Pbqivg@mail.gmail.com>
	<alpine.DEB.2.10.1507211819460.30948@sto>
	<WM!aa4cff4a48647dfeb51adbc23faaba1f82d825d5edc7fcfe10aa08a36243c5ffb656060d76dd428676a64e1e72c8a672!@asav-2.01.com>
	<55AEDDA4.8020009@agliodbs.com>
	<alpine.DEB.2.10.1507220706260.5636@sto>
	<WM!36f7f6aea11042e334dd8ddca8dd52df3de0913ec1f5bc42bfcc27f3eb60d576c8dac02c33f02b88abead156dfec3da0!@asav-2.01.com>
	<55AFD8C6.8010507@agliodbs.com>
	<CA+TgmobZSBmWzugAQp94=q98c2fmSBc+gRPwfNM+94dhjpL3tg@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-hackers>


> Yes, I think that's a good idea.  I don't know whether : is the right
> separator; I kind of line @.  But that's bikeshedding.

Possible ASCII contenders should avoid shell and filename interaction, 
which exclude * ? ! & / < > [ ] . - $ and so on: those that seem to 
remain are @ , = : % # +. I like "%" because this is about sharing, 
although this is not a percentage.

> I'd actually like to introduce a new pgbench option that selects a 
> builtin script by name, so that we can have more than three of them 
> without running out of option names (or going insane).  So suppose we 
> introduce pgbench -b BUILTIN_NAME, where BUILTIN_NAME is initially one 
> of these:
> classic, classic-simple-update, classic-select-only
>
> Then you can do pgbench -b classic@1 -b classic-select-only@9 or
> similar to get 10% write, 90% read.

I like this idea, as -b/-f would be symmetric. Prepending classic to the 
names does not look necessary. I would suggest "tpcb-like", 
"simple-update" & "select-only", or even maybe any prefix. If the bench 
scripts could be read from some pg directory instead of being actually 
inlined, even more code could be dropped from pgbench.

-- 
Fabien.


-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers



view thread (92+ messages)  latest in thread

Message-ID: <alpine.DEB.2.10.1507231759400.10585@sto>
Permalink:  ../alpine.DEB.2.10.1507231759400.10585@sto/
Also on:    postgresql.org/message-id/alpine.DEB.2.10.1507231759400.10585@sto

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-hackers@postgresql.org
  Cc: coelho@cri.ensmp.fr, robertmhaas@gmail.com, josh@agliodbs.com
  Subject: Re: pgbench stats per script & other stuff
  In-Reply-To: <alpine.DEB.2.10.1507231759400.10585@sto>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox