|Pivotal Greenplum (GPDB)||4.3.x|
When performing an incremental backup using gpcrondump utility, can we only just backup just the changes for HEAP tables instead of the entire table?
Per the current design of gpcrondump, when an incremental backup is ran, state files are not generated for HEAP tables since they get backed up with every incremental backup. Currently, the gpcrondump utility only compares the state of each table in the database against the last backup using state files. If there are any change in the state of the table since last backup, it is marked dirty and is backed up during incremental backup. This procedure currently is followed only for AO/CO tables.
A new feature request was submitted to Pivotal Greenplum Engineering team to ask for state files for HEAP tables.