Re: check for interrupts in set_rtable_names - Mailing list pgsql-hackers

From Tom Lane
Subject Re: check for interrupts in set_rtable_names
Date
Msg-id 8792.1447456432@sss.pgh.pa.us
Whole thread Raw
In response to check for interrupts in set_rtable_names  (Jeff Janes <jeff.janes@gmail.com>)
Responses Re: check for interrupts in set_rtable_names  (Jeff Janes <jeff.janes@gmail.com>)
List pgsql-hackers
Jeff Janes <jeff.janes@gmail.com> writes:
> Someone sent my server a deranged query, it tripped my
> auto_explain.log_min_duration setting, that hit some kind of
> pathological case while assigning aliases, and now it sits
> uninterruptibly in set_rtable_names for hours.

> Is there any reason we can't check for interrupts in set_rtable_names,
> like the attached?

There's probably no reason not to do that, but I'd be much more interested
in eliminating the slowness to begin with ...
        regards, tom lane



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Inaccurate results from numeric ln(), log(), exp() and pow()
Next
From: Jeff Janes
Date:
Subject: Re: check for interrupts in set_rtable_names