Re: path toward faster partition pruning

From: Amit Langote <Langote_Amit_f8(at)lab(dot)ntt(dot)co(dot)jp>
To: Beena Emerson <memissemerson(at)gmail(dot)com>, Rajkumar Raghuwanshi <rajkumar(dot)raghuwanshi(at)enterprisedb(dot)com>
Cc: David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>, Dilip Kumar <dilipbalaut(at)gmail(dot)com>, Pg Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: path toward faster partition pruning
Date: 2017-10-25 07:37:05
Message-ID: 75ba17e8-ebb7-3ad1-138f-1008863910b8@lab.ntt.co.jp
Views: Raw Message | Whole Thread | Download mbox
Thread:
Lists: pgsql-hackers

On 2017/10/25 15:47, Amit Langote wrote:
> On 2017/10/24 1:38, Beena Emerson wrote:
>> I had noticed this and also that this crash:
>>
>> tprt PARTITION BY RANGE(Col1)
>> tprt_1 FOR VALUES FROM (1) TO (50001) PARTITION BY RANGE(Col1)
>> tprt_11 FOR VALUES FROM (1) TO (10000),
>> tprt_1d DEFAULT
>> tprt_2 FOR VALUES FROM (50001) TO (100001)
>>
>> EXPLAIN (COSTS OFF) SELECT * FROM tprt WHERE col1 BETWEEN 20000 AND 70000;
>> server closed the connection unexpectedly
>> This probably means the server terminated abnormally
>> before or while processing the request.
>> The connection to the server was lost. Attempting reset: Failed.
>> !>
>
> ...and this (crash) were due to bugs in the 0005 patch.

[ .... ]

> Should be fixed in the attached updated version.

Oops, not quite. The crash that Beena reported wasn't fixed (or rather
reintroduced by some unrelated change after once confirming it was fixed).

Really fixed this time.

Thanks,
Amit

Attachment Content-Type Size
0001-Add-new-tests-for-partition-pruning-v4.patch text/plain 36.9 KB
0002-Planner-side-changes-for-partition-pruning-v4.patch text/plain 41.0 KB
0003-Implement-get_partitions_from_clauses-v4.patch text/plain 31.1 KB
0004-Some-interface-changes-for-partition_bound_-cmp-bsea-v4.patch text/plain 10.1 KB
0005-Implement-get_partitions_for_keys-v4.patch text/plain 19.5 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Pavel Stehule 2017-10-25 08:57:51 Re: pgbench more operators & functions
Previous Message Amit Langote 2017-10-25 06:47:46 Re: path toward faster partition pruning