Re: Some queries starting to hang - Mailing list pgsql-performance

From Andrew Sullivan
Subject Re: Some queries starting to hang
Date
Msg-id 20060606162019.GC10018@phlogiston.dyndns.org
Whole thread Raw
In response to Re: Some queries starting to hang  (Greg Stark <gsstark@mit.edu>)
List pgsql-performance
On Tue, Jun 06, 2006 at 11:37:46AM -0400, Greg Stark wrote:

> An alternate approach would be to implement a SIGINFO handler that
> prints out the explain analyze output for the data built up so far.
> You would be able to keep hitting C-t and keep getting updates
> until the query completes or you decided to hit C-c.

This is even better, and pretty much along the lines I was thinking
in my other mail.  If you can see the _first_ spot you break, you can
start working.  We all know (or I hope so, anyway) that it would be
better to get the full result, and know everything that needs
attention before starting.  As nearly as I can tell, however, they
don't teach Mill's methods to MBAs of a certain stripe, so changes
start getting made without all the data being available.  It'd be
nice to be able to bump the set of available data to something
higher than "none".

(That said, I appreciate that there's precious little reason to spend
a lot of work optimising a feature that is mostly there to counteract
bad management practices.)

A

--
Andrew Sullivan  | ajs@crankycanuck.ca
When my information changes, I alter my conclusions.  What do you do sir?
        --attr. John Maynard Keynes

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: Some queries starting to hang
Next
From: "Craig A. James"
Date:
Subject: Re: Some queries starting to hang