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.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/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
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general