Обсуждение: Partitioning table by multiple columns

Hi there,
I need to partition a table by value of two columns: id_1 and id_2. They are
both bigint.


Anyone have experience in this? Anyone know how can I do this partitioning?

Thanks in advance.

Meph



--
View this message in context: http://postgresql.nabble.com/Partitioning-table-by-multiple-columns-tp5871764.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

On 10/28/15 6:57 AM, mephysto wrote:
> Hi there,
> I need to partition a table by value of two columns: id_1 and id_2. They are
> both bigint.
>
>
> Anyone have experience in this? Anyone know how can I do this partitioning?

It will work just like regular table partitioning. You just need to
account for 2 columns instead of just one. The Fine Manual has the
details: http://www.postgresql.org/docs/9.4/static/ddl-partitioning.html
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Experts in Analytics, Data Architecture and PostgreSQL
Data in Trouble? Get it in Treble! http://BlueTreble.com