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