Jeff Janes writes:
> On Sat, Mar 28, 2015 at 3:37 PM, Tom Lane 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
>> in
On Sat, Mar 28, 2015 at 3:37 PM, Tom Lane wrote:
> Jeff Janes writes:
> > Analyze on functional indexes cannot be interrupted very easily.
> > ...
> > The attached patch fixes it, but don't vouch for its safety.
>
> Hm. The other per-sample-row loops in analyze.c use vacuum_delay_point()
> rath
Jeff Janes writes:
> Analyze on functional indexes cannot be interrupted very easily.
> ...
> The attached patch fixes it, but don't vouch for its safety.
Hm. The other per-sample-row loops in analyze.c use vacuum_delay_point()
rather than CHECK_FOR_INTERRUPTS() directly. Ordinarily that wouldn
Analyze on functional indexes cannot be interrupted very easily.
Example:
create language plperl;
create table foo1 as select x::text from generate_series(1,1000) foo (x);
create table foo2 as select reverse(x) from foo1;
--use a fast version to set up the demo, as we are impatient
CREATE or repl