Re: pgsql: Fix some issues with step generation in partition pruning.

2020-08-03 Thread Tom Lane
Robert Haas writes: > While I like having HP-UX buildfarm coverage, the status page says > that gaur is running 10.20, which according to noted reliable source > Wikipedia, was released in 1996 and went out of support in 2003. So I > wonder whether testing that version is really a sensible thing t

Re: pgsql: Fix some issues with step generation in partition pruning.

2020-08-03 Thread Robert Haas
On Sat, Aug 1, 2020 at 2:16 PM Tom Lane wrote: > There wasn't any amazingly good reason to be using -O1 for gaur, > so I've switched the animal to use -O2. I expect it'll go back > to green in a few hours. While I like having HP-UX buildfarm coverage, the status page says that gaur is running 10

Re: pgsql: Fix some issues with step generation in partition pruning.

2020-08-01 Thread Etsuro Fujita
On Sun, Aug 2, 2020 at 3:16 AM Tom Lane wrote: > I've concluded that this is probably a compiler bug. It doesn't fail > at optimization level -O0 or -O2, only -O1; and trying to step through > gen_partprune_steps_internal() suggests that the part_scheme local > variable is changing value, which i

Re: pgsql: Fix some issues with step generation in partition pruning.

2020-08-01 Thread Tom Lane
Etsuro Fujita writes: > On Sat, Aug 1, 2020 at 11:13 PM Tom Lane wrote: >> Sure looks that way, doesn't it? I'm just now working to reproduce >> on gaur's host and poke into it with a debugger. More news in an >> hour or two (it's slow :-(). > Thanks for that! I've concluded that this is prob

Re: pgsql: Fix some issues with step generation in partition pruning.

2020-08-01 Thread Etsuro Fujita
On Sat, Aug 1, 2020 at 11:13 PM Tom Lane wrote: > Thomas Munro writes: > > Hi Fujita-san > > I wonder if this build farm failure is related? Thanks for letting me know! > Sure looks that way, doesn't it? I'm just now working to reproduce > on gaur's host and poke into it with a debugger. More

Re: pgsql: Fix some issues with step generation in partition pruning.

2020-08-01 Thread Tom Lane
Thomas Munro writes: > Hi Fujita-san > I wonder if this build farm failure is related? Sure looks that way, doesn't it? I'm just now working to reproduce on gaur's host and poke into it with a debugger. More news in an hour or two (it's slow :-(). regards, tom lane

Re: pgsql: Fix some issues with step generation in partition pruning.

2020-08-01 Thread Thomas Munro
On Tue, Jul 28, 2020 at 2:01 PM Etsuro Fujita wrote: > src/backend/partitioning/partprune.c | 187 ++ Hi Fujita-san I wonder if this build farm failure is related? Program terminated with signal 11, Segmentation fault. ... #0 0x59c15c in gen_partprune_steps_inte

pgsql: Fix some issues with step generation in partition pruning.

2020-07-27 Thread Etsuro Fujita
Fix some issues with step generation in partition pruning. In the case of range partitioning, get_steps_using_prefix() assumes that the passed-in prefix list contains at least one clause for each of the partition keys earlier than one specified in the passed-in step_lastkeyno, but the caller (ie,

pgsql: Fix some issues with step generation in partition pruning.

2020-07-27 Thread Etsuro Fujita
Fix some issues with step generation in partition pruning. In the case of range partitioning, get_steps_using_prefix() assumes that the passed-in prefix list contains at least one clause for each of the partition keys earlier than one specified in the passed-in step_lastkeyno, but the caller (ie,

pgsql: Fix some issues with step generation in partition pruning.

2020-07-27 Thread Etsuro Fujita
Fix some issues with step generation in partition pruning. In the case of range partitioning, get_steps_using_prefix() assumes that the passed-in prefix list contains at least one clause for each of the partition keys earlier than one specified in the passed-in step_lastkeyno, but the caller (ie,

pgsql: Fix some issues with step generation in partition pruning.

2020-07-27 Thread Etsuro Fujita
Fix some issues with step generation in partition pruning. In the case of range partitioning, get_steps_using_prefix() assumes that the passed-in prefix list contains at least one clause for each of the partition keys earlier than one specified in the passed-in step_lastkeyno, but the caller (ie,