| From: | "Amit Langote" <Langote_Amit_f8(at)lab(dot)ntt(dot)co(dot)jp> |
|---|---|
| To: | "'Stephen Frost'" <sfrost(at)snowman(dot)net>, "'Robert Haas'" <robertmhaas(at)gmail(dot)com> |
| Cc: | "'Tom Lane'" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "'Andres Freund'" <andres(at)2ndquadrant(dot)com>, "'Alvaro Herrera'" <alvherre(at)2ndquadrant(dot)com>, "'Bruce Momjian'" <bruce(at)momjian(dot)us>, "'Pg Hackers'" <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: On partitioning |
| Date: | 2014-11-13 07:25:22 |
| Message-ID: | 00d901cfff12$fc820f70$f5862e50$@lab.ntt.co.jp |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
> owner(at)postgresql(dot)org] On Behalf Of Amit Langote
> Sent: Thursday, November 13, 2014 3:50 PM
>
> Greenplum uses a single table for this purpose with separate columns for
range
> and list cases, for example. They store allowed values per partition though.
> They have 6 partitioning related catalog/system views., by the way. Perhaps,
> interesting as a reference.
>
> http://gpdb.docs.pivotal.io/4330/index.html#ref_guide/system_catalogs/pg_p
> arti
> tions.html
>
Oops, wrong link. Use this one instead.
http://gpdb.docs.pivotal.io/4330/index.html#ref_guide/system_catalogs/pg_parti
tion_rule.html
> Thanks,
> Amit
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jeff Davis | 2014-11-13 07:26:01 | Re: group locking: incomplete patch, just for discussion |
| Previous Message | Stephen Frost | 2014-11-13 07:19:44 | Re: On the warpath again about ill-considered inclusion nests |