From: | Edson Richter <edsonrichter(at)hotmail(dot)com> |
---|---|
To: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Range partitioning and overlap |
Date: | 2020-11-13 20:29:22 |
Message-ID: | DM6PR13MB3988736CF8F5DC5720440231CFE60@DM6PR13MB3988.namprd13.prod.outlook.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-docs pgsql-general |
Hi,
Using PostgreSQL 13.1 - I need your guidance about corretly implementing partition by timestamp ranges.
Looking at documentation ( https://www.postgresql.org/docs/13/ddl-partitioning.html ) there a statement saying explicit
"Range Partitioning
The table is partitioned into “ranges” defined by a key column or set of columns, with no overlap between the ranges of values assigned to different partitions. For example, one might partition by date ranges, or by ranges of identifiers for particular business objects."
But afterwards, looking into examples, the ranges overlaps:
CREATE TABLE measurement_y2006m02 PARTITION OF measurement
FOR VALUES FROM ('2006-02-01') TO ('2006-03-01');
CREATE TABLE measurement_y2006m03 PARTITION OF measurement
FOR VALUES FROM ('2006-03-01') TO ('2006-04-01');
...
CREATE TABLE measurement_y2007m11 PARTITION OF measurement
FOR VALUES FROM ('2007-11-01') TO ('2007-12-01');
CREATE TABLE measurement_y2007m12 PARTITION OF measurement
FOR VALUES FROM ('2007-12-01') TO ('2008-01-01')
TABLESPACE fasttablespace;
Is there a misinterpretation from my side, or examples are inconsistent with the paragraph above?
Thanks,
Edson
From | Date | Subject | |
---|---|---|---|
Next Message | David G. Johnston | 2020-11-13 20:32:52 | Re: Range partitioning and overlap |
Previous Message | David G. Johnston | 2020-11-13 15:33:26 | Re: tables have merged columns |
From | Date | Subject | |
---|---|---|---|
Next Message | David G. Johnston | 2020-11-13 20:32:52 | Re: Range partitioning and overlap |
Previous Message | David G. Johnston | 2020-11-13 19:30:50 | Re: New "function tables" in V13 documentation |