Re: [SQL] [GENERAL] Monitoring a Query

[Neil Conway]

Bruce Momjian <[EMAIL PROTECTED]> writes:
> Aaron Held wrote:
> > Is there any way to monitor a long running query?
> 
> Oh, sorry, you want to know how far the query has progressed.  Gee, I
> don't think there is any easy way to do that.

Would it be a good idea to add the time that the current query began
execution at to pg_stat_activity?

Cheers,

Neil

-- 
Neil Conway <[EMAIL PROTECTED]> || PGP Key ID: DB3C29FC


---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html

Re: [SQL] [HACKERS] Cursors and backwards scans and SCROLL

[Neil Conway]

On Sun, 2003-03-09 at 16:04, Rod Taylor wrote:
> How about a variable that turns on or off spec enforcement (case #1 or
> #2). On for 7.4, off for 7.5 the next release, and make it disappear
> after that.

Yeah, that sounds like the best solution to me.

IMHO there is a case to be made for skipping straight to defaulting to
'on' in 7.4, and removing the GUC var in 7.5

Cheers,

Neil
-- 
Neil Conway <[EMAIL PROTECTED]> || PGP Key ID: DB3C29FC




---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly