Horton

Re: On partitioning

Amit Langote <langote_amit_f8@lab.ntt.co.jp>

View thread View on postgr.es
From: "Amit Langote" <Langote_Amit_f8@lab.ntt.co.jp>
To: "'Stephen Frost'" <sfrost@snowman.net>, "'Robert Haas'" <robertmhaas@gmail.com>
Cc: "'Tom Lane'" <tgl@sss.pgh.pa.us>, "'Andres Freund'" <andres@2ndquadrant.com>, "'Alvaro Herrera'" <alvherre@2ndquadrant.com>, "'Bruce Momjian'" <bruce@momjian.us>, "'Pg Hackers'" <pgsql-hackers@postgresql.org>
Date: 2014-11-13T07:25:22Z
Lists: pgsql-hackers 
> owner@postgresql.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