-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On Mon, 10 Dec 2007 19:58:21 +0000 Dave Page <[EMAIL PROTECTED]> wrote:
> Neil Conway wrote: > > On Mon, 2007-12-10 at 19:27 +0000, Dave Page wrote: > >> Whilst doing some profiling of the server I found it useful to add > >> an option to pgbench to introduce a delay between client > >> connection setup and the start of the benchmark itself to allow me > >> time to attach the profiler to one of the backends. > > > > "postgres -W n" already does this. It is more flexible to put this > > functionality in the backend that in individual client apps anyway. > > I'm aware of postgres -W, but wanted something that wouldn't get in > the way of other connections and would only affect my pgbench tests. > > If the patch is of no interest, please just ignore it. I just posted > it for anyone that may find it useful - I'm not pushing to have it > committed. I see use for it. Especially in a development environment where you may have various things going on that you have no control over. It is rude to send out a broadcast that says, "Yo... I need to restart postgresql, please stop all productive tasks on your end because I am more important." +1 on enabling client side behavior. Joshua D. Drake - -- === The PostgreSQL Company: Command Prompt, Inc. === Sales/Support: +1.503.667.4564 24x7/Emergency: +1.800.492.2240 PostgreSQL solutions since 1997 http://www.commandprompt.com/ UNIQUE NOT NULL Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate PostgreSQL Replication: http://www.commandprompt.com/products/ -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) iD8DBQFHXZtEATb/zqfZUUQRAiWoAJ0ULTUziKVDkuqXmUyvgYCSA0f+hwCgl/ay SZjqJZIaGLxTBpbuKEzBc4Y= =Ku+C -----END PGP SIGNATURE----- ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings