From: | Amit Langote <Langote_Amit_f8(at)lab(dot)ntt(dot)co(dot)jp> |
---|---|
To: | Rajkumar Raghuwanshi <rajkumar(dot)raghuwanshi(at)enterprisedb(dot)com> |
Cc: | Robert Haas <robertmhaas(at)gmail(dot)com>, Amit Langote <amitlangote09(at)gmail(dot)com>, Ashutosh Bapat <ashutosh(dot)bapat(at)enterprisedb(dot)com>, Pg Hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: Declarative partitioning - another take |
Date: | 2016-10-07 09:20:06 |
Message-ID: | 2e2023f7-e705-6297-bd18-24764ee7c98c@lab.ntt.co.jp |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On 2016/10/07 17:33, Rajkumar Raghuwanshi wrote:
> On Thu, Oct 6, 2016 at 12:44 PM, Amit Langote wrote:
> I have applied latest patches, getting some error and crash, please check
> if you are also able to reproduce the same.
>
> Observation1 : Not able to create index on partition table.
> --------------
> CREATE TABLE rp (c1 int, c2 int) PARTITION BY RANGE(c1);
> CREATE TABLE rp_p1 PARTITION OF rp FOR VALUES START (1) END (10);
> CREATE TABLE rp_p2 PARTITION OF rp FOR VALUES START (10) END (20);
>
> CREATE INDEX idx_rp_c1 on rp(c1);
> ERROR: cannot create index on partitioned table "rp"
This one is a new behavior as I mentioned earlier in my previous email.
> Observation2 : Getting cache lookup failed error for multiple column range
> partition
> --------------
> CREATE TABLE rp1_m (c1 int, c2 int) PARTITION BY RANGE(c1, ((c1 + c2)/2));
>
> CREATE TABLE rp1_m_p1 PARTITION OF rp1_m FOR VALUES START (1, 1) END (10,
> 10);
> ERROR: cache lookup failed for attribute 0 of relation 16429
>
> Observation3 : Getting server crash with multiple column range partition
> --------------
> CREATE TABLE rp2_m (c1 int, c2 int) PARTITION BY RANGE(((c2 + c1)/2), c2);
> CREATE TABLE rp2_m_p1 PARTITION OF rp2_m FOR VALUES START (1, 1) END (10,
> 10);
> 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.
> !>
Fixed. Should have been caught when running the regression tests after I
made changes to 0001 to address some review comments (apparently there was
no test in 0003 that would've caught this, so added a new one, thanks!).
Attached updated patches.
Thanks,
Amit
Attachment | Content-Type | Size |
---|---|---|
0001-Catalog-and-DDL-for-partitioned-tables-9.patch | text/x-diff | 113.3 KB |
0002-psql-and-pg_dump-support-for-partitioned-tables-9.patch | text/x-diff | 26.2 KB |
0003-Catalog-and-DDL-for-partitions-9.patch | text/x-diff | 203.7 KB |
0004-psql-and-pg_dump-support-for-partitions-9.patch | text/x-diff | 20.7 KB |
0005-Refactor-optimizer-s-inheritance-set-expansion-code-9.patch | text/x-diff | 16.2 KB |
0006-Teach-a-few-places-to-use-partition-check-quals-9.patch | text/x-diff | 30.2 KB |
0007-Introduce-a-PartitionTreeNode-data-structure-9.patch | text/x-diff | 8.1 KB |
0008-Tuple-routing-for-partitioned-tables-9.patch | text/x-diff | 43.6 KB |
0009-Update-DDL-Partitioning-chapter-to-reflect-new-devel-9.patch | text/x-diff | 24.7 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Ashutosh Bapat | 2016-10-07 09:27:24 | Re: Declarative partitioning - another take |
Previous Message | Tomas Vondra | 2016-10-07 09:15:37 | Re: Patch: Write Amplification Reduction Method (WARM) |