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