Re: Instability of partition_prune regression test results

2019-09-28 Thread Tom Lane
Amit Langote writes: > On Sat, Sep 28, 2019 at 12:59 AM Tom Lane wrote: >> Amit Langote writes: >>> Isn't the point of using ANALYZE here to show that the exec-param >>> based run-time pruning is working (those "never executed" strings)? >> Hm. Well, if you want to see those, we could do it as

Re: Instability of partition_prune regression test results

2019-09-28 Thread Amit Langote
On Sat, Sep 28, 2019 at 12:59 AM Tom Lane wrote: > Amit Langote writes: > > On Fri, Sep 27, 2019 at 7:25 AM Tom Lane wrote: > >> I experimented with adjusting explain_parallel_append() to filter > >> more fields, but soon realized that we'd have to filter out basically > >> everything that makes

Re: Instability of partition_prune regression test results

2019-09-27 Thread Tom Lane
Amit Langote writes: > On Fri, Sep 27, 2019 at 7:25 AM Tom Lane wrote: >> I experimented with adjusting explain_parallel_append() to filter >> more fields, but soon realized that we'd have to filter out basically >> everything that makes it useful to run EXPLAIN ANALYZE at all. >> Therefore, I th

Re: Instability of partition_prune regression test results

2019-09-26 Thread Amit Langote
On Fri, Sep 27, 2019 at 7:25 AM Tom Lane wrote: > Every so often the partition_prune test falls over, for example > here, here, and here: > > https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=sidewinder&dt=2019-08-15%2021%3A45%3A00 > https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=an

Instability of partition_prune regression test results

2019-09-26 Thread Tom Lane
Every so often the partition_prune test falls over, for example here, here, and here: https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=sidewinder&dt=2019-08-15%2021%3A45%3A00 https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=anole&dt=2019-08-21%2022%3A19%3A23 https://buildfarm.postgre