How is Greenplum's partitioning different from PG's inheritance

From: Rakesh Kumar <rakeshkumar464(at)outlook(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: How is Greenplum's partitioning different from PG's inheritance
Date: 2016-10-31 13:59:00
Message-ID: DM2PR05MB6229E26A3CAE6ACFAD56EB18CAE0@DM2PR05MB622.namprd05.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Reading the following two:

http://www.greenplumdba.com/partitioning-in-greenplum

http://gpdb.docs.pivotal.io/4350/admin_guide/ddl/ddl-partition.html

It is clear that GP's partitioning is just a skin on top of inheritance. Does anyone know how GP implements the insert re-routing. Is it done via triggers, just like we do in PG.

thanks.

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2016-10-31 14:10:44 Re: How to optimize SELECT query with multiple CASE statements?
Previous Message Karsten Hilbert 2016-10-31 13:48:49 Re: Way to quickly detect if database tables/columns/etc. were modified?