Re: pgbench \for or similar loop - Mailing list pgsql-hackers

From Aidan Van Dyk
Subject Re: pgbench \for or similar loop
Date
Msg-id BANLkTin=X5HM4sa87CuTpGJ4vdhqY+NWVQ@mail.gmail.com
Whole thread Raw
In response to Re: pgbench \for or similar loop  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: pgbench \for or similar loop  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
List pgsql-hackers
On Tue, Apr 19, 2011 at 1:22 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:

> I think what that really translates to is "I don't want to bother doing
> the careful design work that Robert talked about". -1 for that approach.

As someone not doing any of that work, agreed ;-)

> I generally feel that such a feature would be better off done
> server-side --- after all, there's more clients in the world than psql
> and pgbench, and not all of them could use a C library even if we had
> one.  But in either case the coding work is going to be dwarfed by the
> design work, if it's done right and not just the-first-hack-that-
> comes-to-mind.

And for the "first-hack-that-comes-to-mind", I find my self pulling
out the named fifo trick all the time, and just leaving my for/loop/if
logic  in bash writing SQL commands to the fifo, occasionally getting
psql to write an answer to a file that I then read back in bash....

a.

--
Aidan Van Dyk                                             Create like a god,
aidan@highrise.ca                                       command like a king,
http://www.highrise.ca/                                   work like a slave.


pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: pgbench \for or similar loop
Next
From: Tom Lane
Date:
Subject: CLUSTER versus broken HOT chains