On Tue, 2006-12-05 at 19:12 -0500, mark@mark.mielke.cc wrote:
> On Tue, Dec 05, 2006 at 02:46:54PM -0800, Joshua D. Drake wrote:
> > Imagine that you are profiling 50 queries, the queries are all the same
> > except for varying where clauses or joins.
>
> Put them in a file.
You mean like the file that psql is nice enough to provide for
me? .psql_history?
>
> Anything worth spending that much time on, is probably worth keeping,
> such that it can be reproduced later.
When it is production yes... it goes into a view or svn depending on
what it is doing.
Joshua D. Drake
>
> Cheers,
> mark
>
--
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997 http://www.commandprompt.com/
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate