Re: Partitioning table by multiple columns - Mailing list pgsql-general

From Jim Nasby
Subject Re: Partitioning table by multiple columns
Date
Msg-id 5630CB95.2090809@BlueTreble.com
Whole thread Raw
In response to Partitioning table by multiple columns  (mephysto <mephystoonhell@gmail.com>)
List pgsql-general
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


pgsql-general by date:

Previous
From: Scott Mead
Date:
Subject: Re: Red Hat Policies Regarding PostgreSQL
Next
From: Adrian Klaver
Date:
Subject: Re: PostgreSQL Timezone and Brazilian DST