Re: compute_index_stats is missing a CHECK_FOR_INTERRUPTS

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
Cc: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: compute_index_stats is missing a CHECK_FOR_INTERRUPTS
Date: 2015-03-29 19:06:48
Message-ID: 27316.1427656008@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Jeff Janes <jeff(dot)janes(at)gmail(dot)com> writes:
> On Sat, Mar 28, 2015 at 3:37 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>> Hm. The other per-sample-row loops in analyze.c use vacuum_delay_point()
>> rather than CHECK_FOR_INTERRUPTS() directly. Ordinarily that wouldn't
>> make much difference here, but maybe a slow index function might be
>> incurring I/O?

> That isn't the case for me (and if it were, they wouldn't be going through
> the buffer manager anyway and so would not trigger delay criteria), but
> that seems like a valid concern in general. It also explains why I
> couldn't find CHECK_FOR_INTERRUPTS in other loops of that file, because I
> was looking for the wrong spelling.

> Adding a vacuum_delay_point does solve the immediately observed problem,
> both the toy one and the more realistic one.

Committed, thanks.

regards, tom lane

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Pavel Stehule 2015-03-29 19:20:45 Re: proposal: row_to_array function
Previous Message Andres Freund 2015-03-29 18:56:19 Relation extension scalability